Conditional Exit
PatzaNov 6 2007 — edited Nov 6 2007Hi,
I have a script file containing the following scripts e.g.:
prompt ----------------------------------------------------------------------------
prompt -- Part 1
prompt ----------------------------------------------------------------------------
connect schema1
execute package1.procedure1();
execute package1.procedure2();
prompt ----------------------------------------------------------------------------
prompt -- Part 2
prompt ----------------------------------------------------------------------------
connect schema2
execute package2.procedure1();
execute package2.procedure2();
Now, I want to check for some condition and if the condition is true then only I start the part 1 of the script else I want to abondon the whole script (including part 2). Can someone plz help me on how to achive this.
Thanks.
-Pat