Re: Calling St. Procedure in UNIX script, How ?

recommened to use this method....

eval sqlplus -s /nologin <<EOS
connect $USER/$PASS
_at_call.sql $PARM1 $PARAM2
EOS as on many machines, unless you are running sqlplus.hode the $USER/$PASS can be seen with the PS command.

[stealth sig]

andrija <ar35644_at_fer.hr> wrote in message news: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 Mon Dec 03 2001 - 00:31:04 CET