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 vote195 views1 answer
Cross apply top for each row t1
SQL
1 vote193 views1 answer
Calculate age in sql postgresql
SQL
3 votes183 views1 answer
Select without null values sql
SQL
0 vote180 views1 answer
Sql select all tables from database change url
SQL
1 vote201 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote179 views1 answer
Stuff in sql server
SQL
7 votes218 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote208 views1 answer
Limit in access query
SQL
0 vote181 views1 answer
How to find the most occuring in SQL
SQL
1 vote203 views1 answer
Influxdb export to csv
SQL