exec sql statement error

[Anonymous]

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.

[TRF]

Share component settings + error trace

[Anonymous]

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.

[cterenzi]

You may need to use the tOracleSP component for that:

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

[Anonymous]

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.

[Anonymous]

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.

[Anonymous]

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?

[Anonymous]

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"