Home » Infrastructure » Unix » Getting output parameter of proc inside shell script
Getting output parameter of proc inside shell script [message #97866] Fri, 28 March 2003 08:55 Go to next message
Victoria
Messages: 152
Registered: July 2002
Senior Member
Hi,
I need to pass an output parameters(parm1,parm2,parm3) from my oracle procedure to shell scripts.

My shell script is
cd $RD
sqlplus $UID/$PWD<<!> aio.log
exec PROC_GET_PARM
!

Inside this how can i access my output parameters...
Any idea...
Thanks
~V~
Re: Getting output parameter of proc inside shell script [message #97878 is a reply to message #97866] Thu, 03 April 2003 15:36 Go to previous message
Anand
Messages: 161
Registered: August 1999
Senior Member
The best way I could think of is to spool the output values to an external OS file through UTL_FILE and then pick up the values from that file.
Previous Topic: strange problem : grep ^- in cron is not working
Next Topic: File size limit exceed
Goto Forum:
  


Current Time: Thu Mar 28 17:21:20 CDT 2024