Piping from Unix to SQL*Plus

From: <venkat_rajagopal_at_my-deja.com>
Date: Fri, 19 Jan 2001 22:15:27 GMT
Message-ID: <94ae9o$8l4$1@nnrp1.deja.com>

Hi,

I've got a problem. I want to pipe a file ( all sql*plus commands inside the file ) to sqlplus .

cat filename | sqlplus -s /

is ok but won't work for me because in my file 'filename' I have '&&' specified in order to accept user input. The above method is ok if I don't have the need for user input. How can I do this? You might be wondering why on earth I need it but I really do. Let me know if you guys have any suggestions and If needed and you so desire I will give you more details.

Thanks

Venkat

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 19 2001 - 16:15:27 CST