I generated DDL script for Oracle 9i database.
In order to run the script in SQLPlus I opened the file in NotePad and Saved As ANSI coding.
The script failed in a number of places. Examination show tables with columns that have default values contain empty lines in their script. SQLPlus is intepreting this as an incorrectly terminated statement.
create table a(
col1 integer constraint c1 not null,
col2 integer default 0
col3 integer default 0
constraint c3 check (...),
col4 integer default 0
Hex editor shows “0a” character after “default 0”.
Unfortunately this is not consistent, another DLL script creation may not have these additional characters.
I didn’t keep the unicode file with the problem. If it occurs again I will check the unicode.
How can we prevent this?