sql*plus interactive in shell script

From: tom-12 <tclavier_at_partner.auchan.com>
Date: Thu, 13 Sep 2001 18:02:57 +0200
Message-ID: <9nql12$df6$1_at_reader1.imaginet.fr>



[Quoted] [Quoted] how can write a sql*plus an interactive sql procedure in shell script ex:

#!/bin/sh
echo Start script
...
echo Start SQL
sqlplus -s log/pass_at_foo<<EOF >/file.log ACCEPT MYTITLE PROMPT 'Title: '
EOF with this i get the string 'Title: ' in my log file but not prompt user ...

thank for your help.

--
Pétition / ECI Telecom :
Pour la demande de documentation technique sur le modem ECI ADSL Hi-Focus USB
affint de développer un driver Linux pour ce modem
http://flashcode.free.fr/eci/index.php3
Received on Thu Sep 13 2001 - 18:02:57 CEST

Original text of this message