topic Re: exec sql statement error in Talend Studio

exec sql statement error

Anonymous — Sat, 16 Nov 2024 08:21:45 GMT

hi ,

i need to execute the quire like exec encrypt_fd.set_card_key(password); i tried using toraclerow but it is giving errors how to execute them.

Re: exec sql statement error

TRF — Mon, 23 Apr 2018 17:03:32 GMT

Share component settings + error trace

Re: exec sql statement error

Anonymous — Mon, 23 Apr 2018 18:11:07 GMT

hi,

i am using toraclerow i am just going with the basic settings and in qurey i am putting qurey and running it and it is giving error.

Error trace: ORA-00900: invalid SQL statement

Qurey is working in sql workbench.

my job is

toraclerow---->toracleinput---->tmap---->toracleoutput.

Since query is exec qurey i am using the toraclerow.

Re: exec sql statement error

cterenzi — Mon, 23 Apr 2018 20:28:58 GMT

You may need to use the tOracleSP component for that:

https://help.talend.com/reader/ezE005k1syi0pq3WAU8WyA/Or3iSV87d~xx6xzHYrUnLA

Re: exec sql statement error

Anonymous — Mon, 23 Apr 2018 21:08:46 GMT

hi ,

it is not working for me . i am using the oracle database and it has procedure to set up password so we can use sql functions after setting password. And procedure to set password is exec encrypt_fd.set_card_key(''); in SQL workbench and i am using same qurey in the talend toraclerow but not working.

Re: exec sql statement error

Anonymous — Mon, 23 Apr 2018 22:00:24 GMT

You need to show us EXACTLY what you have configured. There are SO many things that could be wrong with what you are doing. Take a screenshot of your component configuration and the complete error message.

Re: exec sql statement error

Anonymous — Mon, 23 Apr 2018 22:19:04 GMT

hi ,

i have development schema in oracle which has stored procedures and functions.
this is stored procedure buncle of functions and procedures

you can see in screen shot procedure set_card_key which is needed for if we nedd to run other queries.

calling procedure and executing sql function

so i pass password with 1 qurey and after that i can run other qureies. how can we achive this i am just trying to execute the exec encrypt_fd.set_card_key("pw") using toracle row.it is giving error.

is there a another way to acheive it?

Re: exec sql statement error

Anonymous — Tue, 24 Apr 2018 09:45:23 GMT

Try wrapping your SQL in a BEGIN and END block, remove the semi colons and ensure that it is written within quotes. Like below....

"BEGIN
your.function('56565')

select your,
columns,
here
From your.table

END"