Re: Parameters in and out of unix shell to procedure help please ...

simple,
just use something like
env_var=`sqlplus -s username/password_at_service @script`

That is all!

So change your stored procedure to exec a dbms_output.put_line(<variable>)
and you should be set.

Hth,

Sybrand Bakker, Oracle DBA

Mujahid Hamid <mujahid_at_pharmco.demon.co.uk> schreef in berichtnieuws 955784496.14109.0.nnrp-10.c2de4f17_at_news.demon.co.uk...
> Hi All,
>
> I am calling a stored procedure from Unix shell.
>
> I can pass value to the procedure but I cannot return a
> value back to the Unix and store it in Unix shell variable.
>
> Is there a way where I can return a value from a stored procedure
> to Unix shell script and store it in the Unix shell variable
>
> Following is what I am trying to do.
> I am stuck on this please help ....
>
> Many Thanks
>
> Mujahid
>
> #
> IN_PARA='INPAR'
> OUT_PARA=''
> sqlplus -s username/password <<endsql
> exec STORED_PROCEDURE($IN_PARA,$OUR_PARA);
> endsql
> #
> echo 'Following are the Unix outputs'
> #
> echo $IN_PARA >> VALUE_PASSED.DAT
> echo $OUT_PARA >> VALUE_RETURNED.DA
>
>
Received on Sat Apr 15 2000 - 00:00:00 CDT