topic [resolved] ORA-00942: Table ou vue inexistante with tOracleInput in Talend Studio

[resolved] ORA-00942: Table ou vue inexistante with tOracleInput

Anonymous — Sat, 16 Nov 2024 12:03:05 GMT

hi,
I'm trying to develop a job for updating a table in an Oracle database.
When I run that job I have this error "ORA-00942: Table ou vue inexistante" for my tOracleInput component
It seems that the table name is not valid.
If I change the query and put double quote to the table name it's work fine :
"select * from \"users\""
But I can't do this with a tOracleOutput
note : I have the same problem with column name
Who can I do to update this table without errors ?
Thank you

Re: [resolved] ORA-00942: Table ou vue inexistante with tOracleInput

Anonymous — Mon, 22 Apr 2013 11:37:23 GMT

Hi,
How do you set your DB connection? Do you follow the user guide?
Setting up a DB connection with four chapters General properties, Step A Connection, Table upload and Step A Schema definition.
Best regards
Sabrina

Re: [resolved] ORA-00942: Table ou vue inexistante with tOracleInput

Anonymous — Mon, 22 Apr 2013 14:25:13 GMT

Thank you for your response
I just resolved my problem: the DB connection was good but the table was created like this :
CREATE
TABLE "REFERENTIAL"."users"
(
"lastName" NVARCHAR2(2000),
"username" NVARCHAR2(2000),
?
So I have to set the table name in tOracleinput with \"
And the same for column names in Db Column schema
Thank you for your help

Re: [resolved] ORA-00942: Table ou vue inexistante with tOracleInput

Anonymous — Tue, 23 Apr 2013 03:40:15 GMT

Hi,
Thanks for sharing your experience with us! In addition, we have a component tCreateTable. Perhaps it will be useful for your working.
Best regards
Sabrina