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
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.
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
