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

3 votes151 views1 answer
MySQL DELETE JOIN
SQL
0 vote216 views1 answer
Mql5 datetime get hour
SQL
2 votes202 views3 answers
How do I add a user to a postgres database? cli
SQL
3 votes185 views1 answer
Oracle user quota on tablespace
SQL
0 vote178 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote217 views1 answer
Postgresql remove new line from string
SQL
0 vote183 views1 answer
Minus equivalent in my sql
SQL
2 votes175 views1 answer
Mysql change data type of column
SQL
5 votes160 views1 answer
Oracle ora-00054 causes
SQL
3 votes169 views1 answer
Oracle list invalid password ORA-01017
SQL