Try this:
sqlplus user/pass <<END
exec myPU
exit;
END
-Madhu S
"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:<b4l0d4$1ujt4h$1_at_ID-152732.news.dfncis.de>...
> Hello,
>
> is there a way to start a *stored procedure* (not a SQL script)
> from a Unix *shell script* using SQL+.
>
> I know the way how to start a SQL-Script from the shell,
> as documentation says:
> ...
> sqlplus user/pass @myscript [arg1 ...]
> ...
> And inside this SQL-script you may say
> EXEC myPU ...
>
> We tried it the same way with a PU, with no success ...
> ...
> sqlplus user/pass myPU
> no way ...
> sqlplus user/pass exec myPU
> no way ...
>
> Is it possible at all ? I can hardly imagine that it is not ...
> I did RTFMing but did not find useful tips ...
>
> (Oracle EE 8.1.7, AIX 4.3.3)
>
> TIA
>
> Jan
Received on Tue Mar 11 2003 - 13:10:25 CST
