OraFAQ Forum: Unix » calling pl/sql procedure from unix shell script

Home » Infrastructure » Unix » calling pl/sql procedure from unix shell script

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

calling pl/sql procedure from unix shell script [message #152417]

Fri, 23 December 2005 01:17

supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad

Member

Hi all,

i have one shell script which is calling pl/sql procedure,
2 parameters are passing to this shell from somewhere.here i am using only the second parameter.but the pl/sql procedure is not calling through this shell script.Here is the code what i am trying...

shell script...........
--------------------------------------
#!/bin/sh
#parameters $1,$2

sqlplus -s / @supriya.sql $2
exit 0;
---------------------------------------

supriya.sql.............
---------------------
begin
proc1 (&2);
end;
/
exit 0;
------------------------

individual procedure is working fine.only thing is its not calling from shell script.

pls can anyone helpout in this...(urgent...)

thanks in advance
supriya

Report message to a moderator