topic Re: tOracleOutput_1 - ORA-00928: missing SELECT keyword in Talend Studio

tOracleOutput_1 - ORA-00928: missing SELECT keyword

Anonymous — Fri, 12 Apr 2019 12:15:20 GMT

We are getting below error in toracleoutput component when we are trying to read data from cdv file and inserting data in NESTED table.

ORA-00928: missing SELECT keyword
[ERROR]: artemis_dev.test3_0_1.Test3 - tOracleOutput_1 - ORA-00928: missing SELECT keyword

Please suggest.

Regards,

Vivek

Re: tOracleOutput_1 - ORA-00928: missing SELECT keyword

Anonymous — Fri, 12 Apr 2019 12:42:34 GMT

This error seems to be related to creating views which is strange given what you have described. Can you give us a screenshot of your job and the configuration of your Oracle Output component (basic and advanced)? The other thing to try as a test, is to see if you can use the tOracleRow to do this insert. You will likely need to prepare the insert in a tJava type component first.

Re: tOracleOutput_1 - ORA-00928: missing SELECT keyword

Anonymous — Fri, 12 Apr 2019 13:45:05 GMT

I am giving "NT_PP1,table (ob_pp1)" in table name feild in toracleoutout component ,now getting below error.

ORA-00926: missing VALUES keyword
[ERROR]: artemis_dev.test3_0_1.Test3 - tOracleOutput_1 - ORA-00926: missing VALUES keyword

Regards,

Vivek

Re: tOracleOutput_1 - ORA-00928: missing SELECT keyword

Anonymous — Fri, 12 Apr 2019 15:21:05 GMT

I suspect that this component is not compatible with nested tables. I will investigate this. Have you tried using the tOracleRow to get around this?

Re: tOracleOutput_1 - ORA-00928: missing SELECT keyword

akumar2301 — Fri, 12 Apr 2019 15:49:54 GMT

Nested table works with tOracleRow as suggested here.

Prepare your statement like

"INSERT INTO nested_table VALUES (" + row1.id + ", sub_table(" + row1.subtablecol + "))"

for input like

5; 'A'
6; 'B', 'C'

you can use prepared statement as suggested.

Re: tOracleOutput_1 - ORA-00928: missing SELECT keyword

Anonymous — Tue, 16 Apr 2019 12:13:33 GMT

Hi,

Is there any other way to insert data into nested table.I am reading data from different csv files with dynamic data type.Each csv file data need to insert into different nested table.

Thus looking for more Suitable solution.

Regards,

Vivek