Re: SQL*Plus for Windows Help

On 10 Oct 1997 11:04:32 GMT, karih_at_relatech.fi () wrote:

Thanks for replying. We have got the scripts working with positional parameters as you mention but this would mean changing all the scripts for our customers.

But, if that is what we have to do ...

>robertj_at_kalamazoo.co.uk wrote:
>:
>: We are trying to port some of our Unix scripts to Windows. We run these
>: scripts by redirecting the standard input from a shell script, ie
>:
>: sqlplus user/pass <<END01
>: start <script>
>: <parm1>
>: <parm2>
>: exit
>: END01
>:
>: The script uses ACCEPT to prompt for the parameters to the script.
>:
>: When running plus33.exe under Windows using Tcl, SQL*Plus does not seem to
>: get the input from ACCEPT from standard input but seems to wait for input
>: directly from the keyboard.
>:
>: Has anyone else had this problem or is it a 'feature' of plus33.exe on
>: Windows?
>:
>Your Unix script uses a feature called here document, which is
>a very neat feature. I don't think you can get it to work in Windows.
>
>What you could do is to use following method to execute your sql script:
>plus33 user/pass _at_script parm1 parm2
>
>Then you could refer to your parameters as &1 and &2 in the script.
>You must also put exit as the last line in your script.
>
>Hope this helps
>--
>Kari Hakkinen E-mail: Kari.Hakkinen_at_relatech.fi
>Relatech Ltd Tel: +358-14-4451 205
>Jyvaskyla FINLAND Fax: +358-14-4451 210
>http://www.relatech.fi/ GSM: +358-40-5447 021
Received on Mon Oct 13 1997 - 00:00:00 CEST