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 vote164 views1 answer
Sql string contains case sensitive
SQL
0 vote173 views1 answer
Delete ids between sql
SQL
0 vote150 views1 answer
Mysql match in serialized data
SQL
7 votes172 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote164 views1 answer
How to put is null in where in clause
SQL
0 vote151 views2 answers
Pl sql auto increment
SQL
0 vote167 views2 answers
Import .sql into postgres db command
SQL
8 votes111 views2 answers
Alter column name in mssql
SQL
0 vote169 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote163 views1 answer
Sql express database size limit
SQL