RE: aborting a SQL script based upon DB name

Same idea, but instead of aborting I do conditional dynamic sql:

declare

   dbname global_name.global_name%TYPE; begin

   select global_name into dbname

      from global_name;

   if dbname = 'LVLSDP' then

        EXECUTE IMMEDIATE '..............';
   end if;
end;
/

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Greg Norris Sent: Thursday, May 19, 2005 8:50 AM
To: ORACLE-L
Subject: aborting a SQL script based upon DB name

I was recently asked how to setup a SQL script, to ensure that it aborts if accidentally run on the wrong database. The scriptlet below is what I came up with... it seems to work just fine, but got me curious about alternate approaches. Anyone care to share a substitute, or comment on the futility of life in general? ;-)

• <snip> ----- -- ensure that the following block aborts the script on error whenever sqlerror exit 100

declare

   dbname global_name.global_name%TYPE; begin

   select global_name into dbname

      from global_name;

   if dbname !=3D 'LVLSDP' then

      raise_application_error(-20001,'I pity ''da fool who connects to ''da wrong database!!!');

   end if;
end;
/

• back to the default behaviour whenever sqlerror continue ----- <snip> -----

--=20
"I'm too sexy for my code." - Awk Sed Fred.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l