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 vote141 views1 answer
Convert sql server guid to varbinary
SQL
4 votes178 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote141 views1 answer
Print boolean in plsql
SQL
0 vote154 views2 answers
Faster mysql imports
SQL
0 vote217 views1 answer
Mysql disable triggers
SQL
0 vote171 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote146 views1 answer
Rename view mysql
SQL
0 vote155 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote147 views1 answer
Sqlplus change user
SQL
5 votes177 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL