OraFAQ Forum: SQL & PL/SQL » To get the value returned from a proc/Function with in a shell script

Home » SQL & PL/SQL » SQL & PL/SQL » To get the value returned from a proc/Function with in a shell script

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

To get the value returned from a proc/Function with in a shell script [message #10040]

Fri, 26 December 2003 02:03

Prashanth
Messages: 41
Registered: September 1999

Member

Hi
i need a local shell variable (in a Unix Shell Script) to handle the value returned by a procedure/function with in a Unix Shell Script.
Shall be glad to get any solutions
thnks in adv
:-)

Report message to a moderator

Re: To get the value returned from a proc/Function with in a shell script [message #10061 is a reply to message #10040]

Tue, 30 December 2003 03:42

Heike
Messages: 3
Registered: October 2002

Junior Member

Hello,
I have a little example.

XX=`sqlplus -s system/manager <<!
< !
set heading off
select user from dual;
exit;
!`
echo $XX

With kind regards
Heike

Report message to a moderator

Re: To get the value returned from a proc/Function with in a shell script [message #10099 is a reply to message #10061]

Mon, 05 January 2004 18:39

Rajesh Babu
Messages: 6
Registered: March 2003

Junior Member

Hi Heike
Thanks a lot, even iam looking for it.

Thanks you very much.

Regards
Rajesh

Report message to a moderator

Previous Topic:	parameter in SQL command
Next Topic:	HOW TO BINBIND VARIABLE IN FUNCTION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 22:20:07 CDT 2024