ORA-00911 error
Moderators: chulett, rschirm, roy
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 !
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
Regards
MK
What would you attempt to do if you knew you could not fail?
-----------------------------------
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: