I create a shell script in order to logon and run the .sql script. It does logon, but
it stays at the SQL> prompt and does not runt he script. I don't know what did
I do wrong.
Your problem is that once sqlplus starts, it never gets to the next step in your .sh script. The .sql script must be run as part of the command line call to sqlplus.
sqlplus (username)/(password) @sample.sql
This solved my question too.
cool....it works....thank you so much Jeff
Thanks Jeff, this solved my question too!
Click Here to Expand Forum to Full Width