topic Re: ORA-00922 tOracleOutput in Talend Studio

ORA-00922 tOracleOutput

Anonymous — Sat, 16 Nov 2024 10:00:03 GMT

Hi,
I am struggling with the same error for hours using tOracleOutput.
ERROR : ORA-00922: missing or invalid option.
I am using Oracle 12, tried every combination changing the schema on tOracleOutput (length, ..).
I am afraid of a compatibility problem with OJDBC ?
Thanks for help

.. --> TMap --> tOracleOutput --> tOracleCommit

Re: ORA-00922 tOracleOutput

Anonymous — Wed, 15 Mar 2017 02:58:19 GMT

Hi,
Did you get this error when create a table name with hyphen?
Screenshots of job setting will be preferred.
Best regards
Sabrina

Re: ORA-00922 tOracleOutput

Anonymous — Wed, 15 Mar 2017 09:23:46 GMT

Hi Sabrina,
Thanks for your comment, but we don't use any hyphen.
I have tried a very simple job to limit collateral impacts.
1. tGenerate (1 Col of 20 values)
2. tOracleOutput
3. tCommit (+close connection at the end)

Part1 is fine (tested with a tLogRow)
Part2 is crashing. In the Java code, the SQL request is this one:
CREATE TABLE <user>.TABLE2 (
Col1 varchar2(10) not null,
primary key(Col1)
)
Configuration of component:
- Drop table if exists and create
- Update or insert
Status at execution start: no table in the DB, Connection is fine.
Manual SQL request with same user from Oracle Developer tool is working fine.

Thanks for your help,

Re: ORA-00922 tOracleOutput

Anonymous — Thu, 16 Mar 2017 08:21:08 GMT

Hi,
Could you please post your toralceOutput component setting screenshot into forum? Which will be helpful for us to address your issue.
Best regards
Sabrina