Re: Passing UNIX shell variables to a stored procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 4 Nov 2003 00:19:10 +0100
Message-ID: <bo8tk6$1bh2ms$1@ID-62141.news.uni-berlin.de>

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

Yes, that is possible. Please look up how to pass commandline parameters to sql*plus in your sql*plus reference manual.

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Nov 03 2003 - 17:19:10 CST