Re: sqlplus exit code

"Justin" <e_fax_t_at_msn.ZAPME.com> wrote in message news:3f0b252c$0$6523$afc38c87_at_sisyphus.news.be.easynet.net...
> Hi,
>
> on unix I see that I can control the exit code sqlplus
> returns to the shell through the 'exit' command. Fine.
> Is there an easy way to pass on the integer return code
> of a pl/sql function as exit code, then?
>
> Thanks in advance!

Yes its possible.
Something like:

var ret_code NUMBER

begin :ret_code := myfunc(param,param); end; /

exit :ret_code;

.....

or

col ret_code new_value ret_code
select myfunc(param,param) ret_code from dual;

exit &ret_code

I'm not sure .. but the above examples might be subject to some limitations

HTH
Anurag Received on Tue Jul 08 2003 - 18:28:09 CDT