topic Re: execute oracle sql query file in Talend Studio

execute oracle sql query file

paresh1 — Sat, 16 Nov 2024 01:56:20 GMT

Hi,

First of all I am new to Talend.

I am trying to execute Oracle sql query file which has simple query as select * from schema.tablename;

using tFileInputFullRow--->tOracleRow(query--->(String)globalMap.get("line"))----->tFileOutputExcel.

Getting error as SQL statement to execute cannot be empty or null

I have attached the screenshot of job.

Please help in the above issue.

Thanks

Re: execute oracle sql query file

David_Beaty — Thu, 09 Jul 2020 18:04:28 GMT

Hi,

You probably need to go:

tFileInputFullRow ->tSetGlobalVar ("line" = row1.line" or something similar

tOracleRow (String)globalMap.get("line")

Re: execute oracle sql query file

David_Beaty — Thu, 09 Jul 2020 18:04:28 GMT

Hi,

You probably need to go:

tFileInputFullRow ->tSetGlobalVar ("line" = row1.line" or something similar

tOracleRow (String)globalMap.get("line")

Re: execute oracle sql query file

paresh1 — Thu, 09 Jul 2020 18:28:01 GMT

Hi David,

Thanks for the solution.

Now that error has vanished.

It came up with new error "ORA-00900: invalid SQL statement".

Also tried by giving schema name too.

Re: execute oracle sql query file

paresh1 — Thu, 09 Jul 2020 18:28:01 GMT

Hi David,

Thanks for the solution.

Now that error has vanished.

It came up with new error "ORA-00900: invalid SQL statement".

Also tried by giving schema name too.

Re: execute oracle sql query file

Anonymous — Thu, 09 Jul 2020 19:16:20 GMT

Do not add the ; at the end of the statement.

The semicolon is not part of the statement and will only be used to separate multiple statements in tools like DBeaver or SQLPlus. The database it self expects the single statement without ;

Oracle does not allow multiple statements in in JDBC statement unlike MySQL (here you can execute multiple statements at once).

Re: execute oracle sql query file

Anonymous — Thu, 09 Jul 2020 19:16:20 GMT

Do not add the ; at the end of the statement.

The semicolon is not part of the statement and will only be used to separate multiple statements in tools like DBeaver or SQLPlus. The database it self expects the single statement without ;

Oracle does not allow multiple statements in in JDBC statement unlike MySQL (here you can execute multiple statements at once).

Re: execute oracle sql query file

paresh1 — Tue, 14 Jul 2020 11:35:41 GMT

Thanks a lot jlolling and David. Both of your answers helped me to get out of the issue.👍 👌