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

From: jane <janeyiu_at_optonline.net>
Date: Thu, 29 Nov 2001 22:16:49 GMT
Message-ID: <ltyN7.5711$z8.965524@news02.optonline.net>

>...call st. procedures inside SQL Plus...

Thanks !
Right, of course one'll do that. possibly the most straight-forward way. Do you have a sample snippet to provide me ? i.e. if you have a UNIX variable $my_table (= dept) how do you invoke sql*plus and pass $my_table to a pl/sql procedure which you'd otherwise manually run in sql*plus as sql> exec check_table('dept')
Thanks

jane

"Leonid Boitsov" <itman_at_narod.ru>
> You can call st. procedures inside SQL Plus or Embeded SQL, or Java,
or
> from anywhere that have Oracle API,
> but shell (as far as I know) has not. You can, however, call SQL Plus
inside
> shell scripts passing to it scripts created on-the-fly via, say, standard
> input.
>
> Leonid
Received on Thu Nov 29 2001 - 16:16:49 CST