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

9 votes287 views3 answers
Postgres make sql dump
SQL
17 votes255 views3 answers
Cast in sql server
SQL
0 vote232 views1 answer
Sql requete number pair
SQL
1 vote277 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote271 views1 answer
Mysql exception output
SQL
0 vote264 views1 answer
Sql get month from date
SQL
0 vote282 views1 answer
Change role postgres
SQL
5 votes262 views1 answer
Sqlite alter table add column
SQL
15 votes276 views4 answers
Create table if not exists sql
SQL
4 votes237 views2 answers
How to delete row in sql
SQL