This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.