sqlldr issues...

[nandini lagunia]

Hi,

I am using sqlldr utility in my java application.
The only hitch is when I try to load data in the database making one field null where the
column in the database corresponding to that field is not nullable, it simply logs the error
message in the log file and doesn't tell me if any error has occurred.

If I wish to find if any error has occurred during loading, will I have to dive into the
created log file and search for the error(s) ???

I don't think it's a smart way of doing things.
Do you know any workaround???

Thanks in advance.

[Christophe Verré]

Isn't a ".bad" file generated ?

[nandini lagunia]

Yeah... a bad file is generated.
But my question is will I have to skim through the generated .bad file in order to find if any error has occurred during data loading??

[Christophe Verré]

No. You just have to remove the file before loading, and after calling sqlldr, check if the file is there. If it's there, then an error occurred.

[nandini lagunia]

okk...

That means I'll have to skim through .bad and .log file to display the errors.