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.
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
Since query is exec qurey i am using the toraclerow.
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.
i have development schema in oracle which has stored procedures and functions.
you can see in screen shot procedure set_card_key which is needed for if we nedd to run other queries.
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?