Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bash script not continuing after running SQL script 2

Status
Not open for further replies.

peterneve

Programmer
Jan 24, 2002
50
GB
I have a script that runs an SQL script by calling it like:

Code:
sqlplus -S username/password @freespce.sql

This executes fine, but then sqlplus waits for me to type 'quit' before the rest of the bash script runs. Is there a command line option that I am missing?

Any ideas?

Thanks :)
 
That's ok if I am just running it manually, but the idea of the script is to hopefully run it as a cron job, so I don't really want to have any user input at all.

Thanks
 
Peter,
Perhaps you misunderstood Sem. The last line of freespce.sql should be:
Code:
quit;
That way after it finishes executing, it will exit SQL*Plus. No user input required.

Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw
Systems Project Analyst/Custom Forms & PL/SQL - Oracle/Windows
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top