Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Passing UNIX shell variables to a stored procedure

Re: Passing UNIX shell variables to a stored procedure

From: Lakshmi Jagarlapudi <jlnarayana_at_comcast.net>
Date: Thu, 06 Nov 2003 02:50:50 GMT
Message-ID: <eGiqb.85977$275.251834@attbi_s53>


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...

> 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.
Received on Wed Nov 05 2003 - 20:50:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US