OraFAQ Forum: SQL & PL/SQL » How can you keep your SQL Session active?

Home » SQL & PL/SQL » SQL & PL/SQL » How can you keep your SQL Session active?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can you keep your SQL Session active? [message #37527]

Wed, 13 February 2002 02:23

Majad Hussain
Messages: 1
Registered: February 2002

Junior Member

I want to run a number of SQL scripts which will contain exit commands when the script is complete.
But when the first script finishes the SQL session is killed and returns to the command prompt.

How can i maintain the SQL session and still run multiple SQL scripts ?

Report message to a moderator

Re: How can you keep your SQL Session active? [message #37541 is a reply to message #37527]

Wed, 13 February 2002 10:02

Grant
Messages: 578
Registered: January 2002

Senior Member

I ended up taking the exits out. The ones I couldn't I ended up writing a script like:

sqlplus username/password@alias @script1.sql
sqlplus username/password@alias @script2.sql

and so on.

Report message to a moderator

Previous Topic:	View Text
Next Topic:	How to calculate the difference between dates on different rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:33:48 CDT 2024