Re: Calling St. Procedure in UNIX script, How ?
From: andrija <ar35644_at_fer.hr>
Date: Fri, 30 Nov 2001 10:20:02 +0100
Message-ID: <9u7j03$e0jj$1_at_as201.hinet.hr>
Date: Fri, 30 Nov 2001 10:20:02 +0100
Message-ID: <9u7j03$e0jj$1_at_as201.hinet.hr>
Make two files:
call.sql - where your call to procedure is:
exec myproc('&1','&2');
exit;
And shell script:
sqlplus -s $USER/$PASS _at_call.sql $PARAM1 $PARAM2
"jane" <janeyiu_at_optonline.net> wrote in message
news:sojN7.208$rS6.61809_at_news02.optonline.net...
> How does one call stored procedures in UNIX
> shell script (I'll take any flavor, thanks) and
> mostly, pass shell variables as parameters ?
>
> Thanks very much !
> jane yiu
>
>
Received on Fri Nov 30 2001 - 10:20:02 CET