I am having a job sequence
uservariableactivity--->execute command activity
In the execute command acitvity, I am using a SQL statement to delete records from a table
In command:
Code: Select all
echo "SET HEADING OFF;\n delete from CUST.CUST_BAL where seq_id ='#uservariableactivity.seq_id#';\n exit\n" | sqlplus -s Userid/PWD@SERVER
uservariableactivity.seq_id is a variable which i derive from uservariable activity.
But If i run this job sequence, it simply hangs and run forever.
Instead of job parameter, if i hard code the value like
Code: Select all
echo "SET HEADING OFF;\n delete from CUST.CUST_BAL where seq_id ='123ABC';\n exit\n" | sqlplus -s Userid/PWD@SERVER
this command runs and deletes the records as expected
I tried this command even without quotes on two sides of #uservariableactivity.seq_id
Code: Select all
echo "SET HEADING OFF;\n delete from CUST.CUST_BAL where seq_id =#uservariableactivity.seq_id#;\n exit\n" | sqlplus -s Userid/PWD@SERVER
ERROR at line 1:
ORA-00933: SQL command not properly ended
How do i overcome this?
Thanks in advance,
Raja R P