Re: Batch input for SQLPLUS

>Subject: Batch input for SQLPLUS
>From: Arulmozhi Sengodan Arulmozhi.Sengodan_at_us.bosch.com
>Date: Tue, 07 December 1999 11:18 AM EST
>Message-id: <82jc30$eb0$1_at_proxy2.fe.internet.bosch.de>
>
>Hi,
>
>I am a newbie to Oracle. I am converting scripts from Unix to NT. I have a
>SQL Script file on Unix which is of the type:
>sqlplus scott/tiger _at_some << abc
>1230 ;these are inputs to sqlplus
>2340 ;these are inputs to sqlplus
>abc
>or do until you encounter abc.
>
>I tried the script on Oracle on NT with SQLPLUS 8.0 and it does not accept
>"<<" this. I need some way to have to input the required values to the
>sqlplus for a batch operation.
>
>Any help is most welcome
>
>
You can pass argument to a SQLPLUS job by referencing &1, &2 etc in your SQLPLUS script

Look in the documentation for SQLPLUS for more info.

HTH
Dan Hekimian-Williams Received on Thu Dec 09 1999 - 06:45:33 CET