>
> "Yechiel Adar"
> <[EMAIL PROTECTED]>To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> [EMAIL PROTECTED] Subje
cc:
[EMAIL PROTECTED] Subject: Re: passing parameters to a
stored procedu
Kranti,
Something like this:
echo exec pl_sql_procedure('%1'); > run.sql
echo exit >> run.sql
%oracle_home%\bin\sqlplus user/pw @run.sql
Hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesda
Use &1 &2 for the parameters passed from the command line.
If you had (test.sql) a script like:
select &1 from dual;
exit;
and you write on the command line:
sqlplus Scott/tiger@db @test.sql 'kuku'
It will become:
select 'kuku' from dual;
Yechiel Adar
Mehish
- Original Message -
To: Mu
Hi all,
I am running a batch file through which I am opening SQLPLUS session
and calling a stored procedure. I want to pass parameters to this procedure
from the command prompt. Is it possible? Can anyone on this list will help
me.
Environment is Oracle 8.1.7 and OS Win2k.
Thanx,
Kranti Pu