RE: How to stop script

Ave !

Here is one possible solution.

Create two tiny scripts. First script let say ex.sql which includes only word exit and linefeed and second one cont.sql which has only one space character, nothing else. Then in Your sql script:

--
column NAME noprint new_value SCRIPT_NAME

select decode(name,'TEST','cont.sql','ex.sql') NAME from v$database;

@&SCRIPT_NAME  
--

So if Your database is TEST, then You run cont.sql (nothing happens), 
but if it's something else, You run ex.sql which stops Your sqlplus session.

HTH
Jorma

-----Original Message-----
Sent: 17 June, 2003 07:39
To: Multiple recipients of list ORACLE-L


I have a script and can be run on commandline like: 
 


> sqlplus <usrname>/<password>@TEST @import.sql 

 
 
However, I want to check database name at the beginning of import.sql. I knew 
"select name from v$database" can obtain database name. But how can I stop the 
script if I found it is not TEST database? In import.sql, it is like: 
 
drop user A cascade;    
create user A ....; 
host imp A/[EMAIL PROTECTED] file=a.dmp full=yes; 
// some PL/SQL ...
 
Thanks! 
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).