One Star

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

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
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

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

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
3 REPLIES
Moderator

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

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
--
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-00942: Table ou vue inexistante with tOracleInput

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
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.