Home » Infrastructure » Unix » calling pl/sql procedure from unix shell script
calling pl/sql procedure from unix shell script [message #152417] Fri, 23 December 2005 01:17 Go to next message
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
Re: calling pl/sql procedure from unix shell script [message #152442 is a reply to message #152417] Fri, 23 December 2005 03:29 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Shouldn't you use "proc1 (&1);" instead of "proc1 (&2);"?

Best regards.

Frank
Re: calling pl/sql procedure from unix shell script [message #152446 is a reply to message #152417] Fri, 23 December 2005 03:58 Go to previous message
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
Member
Thank u,its working

bye
supriya
Previous Topic: shell script to create oracle 10g databases
Next Topic: CPU runaway in AIX
Goto Forum:
  


Current Time: Thu Mar 28 10:41:21 CDT 2024