Oracle drop temporary table

CREATE OR REPLACE PROCEDURE p AS
    table_or_view_not_exist EXCEPTION;
    PRAGMA EXCEPTION_INIT (table_or_view_not_exist, -942);
    attempted_ddl_on_in_use_GTT EXCEPTION;
    PRAGMA EXCEPTION_INIT (attempted_ddl_on_in_use_GTT, -14452);
BEGIN
    EXECUTE IMMEDIATE 'DROP TABLE t';

EXCEPTION
    WHEN table_or_view_not_exist THEN
        dbms_output.put_line('Table t did not exist at drop time. Continuing.');

    WHEN attempted_ddl_on_in_use_GTT THEN
        dbms_output.put_line('Help ! Someone is doing my job!');
        dbms_output.put_line('Please rescue me');
        RAISE;
END p;

Source: stackoverflow.com

Similar codes

10 votes295 views6 answers
Mysql delete duplicates
SQL
0 vote267 views1 answer
Sql comparison operators
SQL
1 vote275 views2 answers
How to check username in mysql command line
SQL
1 vote266 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote285 views1 answer
Mysql foreach insert
SQL
16 votes299 views4 answers
Ascending order mysql
SQL
0 vote246 views1 answer
Flask_sqlalchemy install
SQL
7 votes300 views4 answers
What is my mysql version
SQL
4 votes288 views3 answers
Drop Table Oracle
SQL
0 vote304 views1 answer
SQL SERVER xquery count child nodes
SQL