Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Automatic Exit after PL/SQL script
Name: Dennis_Allan Date: April 19, 2004 at 12:43:31 Pacific OS: UNIX CPU/Ram: Pentium III 1 GIG
Comment:
Hello, I have a Bourne Shell script that first calls sqlldr then logs into SQL Plus to run a PL/SQL script. However, when I run this script, I need to type in 'exit' or <ctrl-d> to get back to the cursor. I would like to be able to run the script and have the cursor return automatically. Here is my script:
Summary: Well, those scripts have to be modified by someone. But here is what I did: #! /bin/sh sqlplus -s scott/tiger@DatabaseName << ENDSQL WHENEVER SQLERROR EXIT 5 WHENEVER OSERROR EXIT 10 SPOOL ${SCI...