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 vote245 views1 answer
Mamp mysql path mac
SQL
2 votes234 views1 answer
Sql find not in list
SQL
12 votes208 views2 answers
Delete all data in neo4j
SQL
1 vote208 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
2 votes210 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote278 views1 answer
Drop view sql
SQL
1 vote219 views1 answer
Sql order by timestamp
SQL
0 vote213 views1 answer
Not between mysql
SQL
-2 votes216 views1 answer
Mysql not empty
SQL
0 vote231 views2 answers
Oracle ora-00054 how to unlock
SQL