Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing UNIX shell variables to a stored procedure
Hi Brad,
I appreciate your question. I am presenting a command which I have not
tried. Please try it.
--- sqlplus -s apps/password_at_dbname << TOKEN begin myproc(p_first => $1, p_second => $2); end; / TOKEN ------ Please let me know. good luck,Lakshmi. "Brad" <brsimmon_at_mobility.com> wrote in message news:7fba17f9.0311031335.7cfc54e2_at_posting.google.com...Received on Wed Nov 05 2003 - 20:50:50 CST
> Hello,
>
> I have a few stored procedures in Oracle 8i and am interested in
> passing UNIX shell variables to some of them upon execution. Is that
> possible and if so how do I go about it?
>
> Thanks in advance,
> Brad.
![]() |
![]() |