-
Hi everyone,
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.
test.sh script
-------------
cd $ORACLE_BASE
sqlplus (username)/(password)
@sample.sql
-
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.
Try...
cd $ORACLE_BASE
sqlplus (username)/(password) @sample.sql
Jeff Hunter
-
This solved my question too.
Elin@trend
-
:)
cool....it works....thank you so much Jeff
-
Thanks Jeff, this solved my question too!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|