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

0 vote130 views1 answer
Oracle array
SQL
6 votes221 views3 answers
Psql show columns of table
SQL
0 vote116 views1 answer
How to check which sp is running in sql server
SQL
1 vote114 views1 answer
Sql server 2012 query history
SQL
17 votes129 views6 answers
Change column name in sql
SQL
3 votes139 views1 answer
Mysql replace string in table
SQL
0 vote137 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote138 views1 answer
Query archive mode
SQL
2 votes127 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote129 views1 answer
How to put value in parameters in mysqldataadapter
SQL