Re: Run Stored Procedures from Shell!!!

"Markus Neumaier" <markus.neumaier_at_rl-ag.de> wrote in message news:<9qmc0b$p96ji$1_at_ID-113543.news.dfncis.de>...
> Hi,
>
> It is possible to start Stored Procedures from a normal Unix Shell Script.
> If it is possible, how?
>
> Best regards Neimoa!!

Stored database procedures can only be executed from an Oracle client like sqlplus or pro*c; however, you can start an Oracle client via a shell and it can call the procedure as in the following example

#!/bin/ksh
sqlplus -s userid/password <<EOF
variable id number
 BEGIN
   :id := 22;
 END;
/
print id
EOF The instream pl/sql script could be changed to an execute stored_proc call.

• Mark D Powell --