Re: Shell script question

nimrodo_at_my-dejanews.com wrote in article <71k22n$4bf$1_at_nnrp1.dejanews.com>...
> I'm trying to call a stored procedure that resturn a value from a shell
> script. I tried something like:
>
> variable rc number
> exec myproc(:rc);
> exit rc
>
> but I can't use Exits that way.. Any idea how I can do that?

Try this:

col rc nopri new_v rc
var rc number
exec myproc(:rc)
set pau off
select :rc rc from dual;
exit &rc
---
 Alexander I.Doroshko, aid_at_grant.kharkov.ua

• Bank "Grant", Kharkov, Ukraine