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 vote269 views1 answer
How to combine rows in sql server procedure
SQL
0 vote272 views1 answer
How to add boolean column in postgresql
SQL
1 vote269 views1 answer
List all triggers in SQL Server
SQL
4 votes273 views2 answers
Tsql utf to local time
SQL
0 vote302 views1 answer
Bigrock database connection string
SQL
6 votes264 views1 answer
Phpmyadmin password root
SQL
7 votes277 views3 answers
Sql server reset auto increment
SQL
0 vote263 views1 answer
Sql select with apostrohpe
SQL
14 votes303 views5 answers
Set password for postgres user ubuntu
SQL
1 vote264 views1 answer
Mysql query where in select
SQL