[resolved] ORA-00911: invalid character if importing data from csv file

One Star

[resolved] ORA-00911: invalid character if importing data from csv file

Dear Team,
I am using Talend ETL tool (Version 5.)
I have created an ETL Job importing data from csv flat file to Oracle DB 10g. I do not make any data conversion so I insert string format to the target table where the column types are also string. I made an update / insert operation.
I can sucessfully update and insert all rows but I get an error message:
ORA-00911: invalid character
Consol display information:
Starting job Staging_Cust_CN1 at 11:22 26/08/2014.
connecting to socket on port 3494
connected
ORA-00911: invalid character
disconnected
Job Staging_Cust_CN1 ended at 11:22 26/08/2014.  
The software does not give me any hints where should I look for the problem. There is no complier error in the code.
I have created my own test file with out special characters but still getting the error.
Where can I find additional information about the error.
Any advice is appreciated.
Thank you!
Best Regards,
Robert

Accepted Solutions
One Star

Re: [resolved] ORA-00911: invalid character if importing data from csv file

Hi Sabrina, Jlolling,
Thank you for your prompt answers!
Issue is resolved.
I did not add the target table definition at the component  tOracleRow, furthermore in the component tOracleRow the check box "die on error" was not checked in.
Best Regards!
Robert

All Replies
Moderator

Re: [resolved] ORA-00911: invalid character if importing data from csv file

Hi,
Is your workflow tfileinputdelimited-->tOracleOutPut?
How did you set your component tOracleOutPut DB? You made an update / insert operation? Did you set Key column for your update operation?
In addition, have you already checked the option "Die on Error" in the DB component properties to see if there is any error info printed on console.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] ORA-00911: invalid character if importing data from csv file

                                                                                                  Hi Sabrina,
Thank you for your prompt answer.
I have a combined key from two rows. This is my tOracleOutPut. Screeen shot. I hope you have a better resolution.
 
An I added the update/insert operation.
If I check the target Table, the data is insert and updated accordingly. The job is running accordingly. But I have that funny error message.
Best Regards,
Robert
                                                
Seventeen Stars

Re: [resolved] ORA-00911: invalid character if importing data from csv file

Could you please check if the there is mismatch between the schema used in the tOracleOutput component and the actual table. If you e.g. attempt to write an char into a numeric field this will also cause such errors.
Moderator

Re: [resolved] ORA-00911: invalid character if importing data from csv file

Hi,
It seems your screenshot is missing. Have you checked "Die on error" option? No error info is printed on console? All your data in .csv file is successfully inserted and updated into your oracle without special character which is unsupported by your oracle?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] ORA-00911: invalid character if importing data from csv file

                                                
One Star

Re: [resolved] ORA-00911: invalid character if importing data from csv file

Hi Sabrina, Jlolling,
Thank you for your prompt answers!
Issue is resolved.
I did not add the target table definition at the component  tOracleRow, furthermore in the component tOracleRow the check box "die on error" was not checked in.
Best Regards!
Robert
Moderator

Re: [resolved] ORA-00911: invalid character if importing data from csv file

Hi rblazsek,
It's glad to see the issue is resolved. Thanks for sharing your solution with us.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.