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

1 vote92 views2 answers
Reset mysqli fetch_arra
SQL
4 votes82 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote99 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote85 views1 answer
Except in sql
SQL
15 votes87 views3 answers
Create table with primary key auto increment in sql
SQL
3 votes142 views1 answer
Apex call duration
SQL
14 votes101 views6 answers
Auto_increment mysql
SQL
8 votes106 views3 answers
SQL column name
SQL
15 votes99 views3 answers
Mysql update add to existing value
SQL
1 vote92 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL