I would like to handle exceptions using PL SQL for the drop able and create table scripts. This would happen when I initially set up the db scripts, I would have a drop table statement preceeding the create table statement. But when the script is being run for the first time, the drop table would result in an error and I would like to handle this error and proceed with the create table. Any suggestions or pointers on how to do this.
SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!
Found out a way to do this. Wrote a Procedure that would take a varchar as parameter and check if this parameter is a table and if yes, it will drop the table and if the table does not exist, the thrown exception will be handled properly and the procedure returns.
SCJP 1.4, SCWCD 1.4 - Hints for you, Certified Scrum Master
Did a rm -R / to find out that I lost my entire Linux installation!