Re: Quit SQLPLUS without exit?

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote in message news:<a20d28ee.0109280505.7e6a6058_at_posting.google.com>...
> sunny313_at_hotmail.com (Sunny Singh) wrote in message news:<f3f27ff5.0109271852.62ef0582_at_posting.google.com>...
> > I want to execute a .sql file to (create a procedure) and exit out
> > after that, without using 'exit;' in the .sql file or SQL prompt.
> > Please help.
>
> If you don't have an explicit exit, sqlplus will issue an implicit exit.
> What do you want to accomplish? The impossible?
>
> Regards,
>
> Sybrand Bakker, Senior Oracle DBA

SQLPLUS will keep on sitting on its SQL prompt if no exit/quit is found in .sql:
Please see below:

$ sqlplus sa/sa_at_lyweb @cr_tab.sql

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 28 14:19:41 2001

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

Table created.

SQL> (control stays here)...

As you see, it did not exit. My question is How can we signal SQLPLUS to exit without really saying EXIT in .sql file. SQLPLUS did not do an implicit exit, as you can see.

Any help is greatly appreciated.

Thanks. Received on Fri Sep 28 2001 - 23:23:54 CEST