tOracleOutput_1 - ORA-00928: missing SELECT keyword

[Anonymous]

Hi 

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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?

[akumar2301]

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.

[Anonymous]

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