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 vote142 views3 answers
Default password of mysql
SQL
12 votes143 views1 answer
Script to add new column in table sql
SQL
1 vote155 views2 answers
Create a unqie constraint mysql
SQL
0 vote145 views1 answer
Sql include rows with 0 values
SQL
1 vote124 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote143 views1 answer
Narural join
SQL
0 vote145 views1 answer
Mysql check datetime equals date
SQL
1 vote136 views2 answers
ImportError: No module named mysql.connector
SQL
3 votes135 views2 answers
Mysql config user password
SQL
0 vote121 views1 answer
Java spring boot connect to sql server
SQL