ORA-00911 error

mk_ds09 · Post by **mk_ds09** » Tue Feb 17, 2009 3:12 am

I have again checked in the unix the file isgood only..no problem with the data...even the columns are properly defined with data types.....
what could be the error....?

If you are getting the ORA-00911, it is quite obvious that you are having the invalid charaters in your data, or they are introduced while your processing.. If you are saying your data is clean, then check out your processing...replace your database stage with the flat file stage and run the job. Check what data is going to the database.. If there are some charaters which should not be there and debug your processing.

If still you think everything is correct, check the character support for the oracle installed. NLS settings for the oracle.
That might be not accpeting the charaters which you are trying to insert !

Hope this helps !

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 17, 2009 3:26 am

What happens if you manually do an insert of the same values?

Do you have any other trigger or default values behind the scene?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 17, 2009 3:33 am

You have marked the thread as Resolved. Please make a post indicating HOW it was resolved.