Home » SQL & PL/SQL » SQL & PL/SQL » Exiting a sqlplus batch session
Exiting a sqlplus batch session [message #3972] Wed, 30 October 2002 08:49 Go to next message
Alexander
Messages: 109
Registered: May 2000
Senior Member
Hi... I'm having problems closing a sqlplus session.

I created the batch: runall.bat

Within runall.bat I have

sqlplus user/user @runstuff

The script runs fine to completion. Afterwards I get a sql prompt. How can I get it to automatically exit after the @runstuff script has been run.

Report message to a moderator

Re: Exiting a sqlplus batch session [message #3973 is a reply to message #3972] Wed, 30 October 2002 08:56 Go to previous messageGo to next message
satish
Messages: 112
Registered: September 2000
Senior Member
write an exit in your script, it will not give you the sqlprompt once the script is complete!!
Regards,
Satish.

Report message to a moderator

Re: Exiting a sqlplus batch session [message #4596 is a reply to message #3972] Mon, 30 December 2002 03:13 Go to previous message
seh chun
Messages: 1
Registered: December 2002
Junior Member
In your runstuff.sql, add the command "exit" at the last line.

Report message to a moderator

Previous Topic: Trigger Creation Help
Next Topic: table creation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 19:52:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.