Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Just checking...drop table fail/success

770280Jun 3 2010 — edited Jun 3 2010
I want to have an output if the drop table was success or fail, is this the best way to do it?
SET serveroutput on

DECLARE
   x            number;
BEGIN
   EXECUTE IMMEDIATE 'drop table mytable';
   DBMS_OUTPUT.put_line('Success.');
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.put_line('Fail.');
END;
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2010
Added on Jun 3 2010
13 comments
1,218 views