Running shell script to start sqlplus and run a qls script

[1971240z]

Hi,

I am trying to write a unix shell script that starts sqlplus and then run a sql script.

What I have tryed is:

#
#
sqlplus /
@ file.sql

#
#

When I run the script it starts sqlplus, but is does not run the next line till I exit sqlplus.

Can anyone help me out with this?

Regards,

 

[rrrkrishnan]

Try this :

sqlplus <<!

$username/$password

@file.sql

!

 

[sem]

Why don't you pass script name as parameter at the same line? Regards, Dima