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 vote259 views1 answer
How to print records of employees hired in particular month in oracle
SQL
7 votes252 views1 answer
Sql management studio display line numbers
SQL
1 vote263 views1 answer
How to use a trigger to validate input data
SQL
12 votes258 views1 answer
Docker mysql random root password
SQL
0 vote260 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote265 views2 answers
Nested query
SQL
11 votes253 views2 answers
Import sql file laravel cmd
SQL
1 vote268 views4 answers
Sequelize migration default value
SQL
10 votes259 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote248 views1 answer
ORACLE SUBSTRING SYNTAX
SQL