Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: calling script from command line
Use &1 and &2 for your two parameters in your SQL-Script!
Sandra Ward schrieb in Nachricht
<3753E602.56C6F229_at_stonehenge-telecom.com>...
>HI all,
>I am having a problem trying to execute a sql script with 2 parameters
>from the
>command line. I wrote a one line .bat file with the following:
>
>sqlplus un/pw_at_db @c:\enter_ip 10.10.2.21 04/05/1999
>
>It's working fine except I cannot get it to recognise the parameters I
>am providing on the command line, it keeps prompting me for the 2
>parameters again.
>
>TIA
>Sandra
>
Received on Tue Jun 01 1999 - 09:02:45 CDT