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~

Report message to a moderator

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.

Report message to a moderator

Previous Topic: strange problem : grep ^- in cron is not working
Next Topic: File size limit exceed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 27 07:49:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.