Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Conditionally quitting Sqlplus

Conditionally quitting Sqlplus

From: Transalp <nick_williamson_at_mentor.com>
Date: 16 Apr 2007 05:44:37 -0700
Message-ID: <1176727477.043257.175770@d57g2000hsg.googlegroups.com> 





Hi all,



Is is possible to do this in 9i and 10g?



I have an upgrade script that does some pre-upgrade checking before
applying schema changes, and I want it to quit before applying the
schema changes if it finds certain problems in the data. I'm just
looking for something like an IF-THEN-QUIT that would work in the
context of an anonymous PL/SQL block.



TIA



Transalp
Received on Mon Apr 16 2007 - 07:44:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US