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 vote336 views2 answers
Mysql allow remote connections
SQL
0 vote339 views1 answer
Rabbitmq ui not working
SQL
20 votes361 views6 answers
Change password in mysql
SQL
0 vote333 views1 answer
Select all columns except one sql
SQL
0 vote363 views1 answer
Distance calculator from lat long sql query
SQL
0 vote339 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote317 views1 answer
Remove transient options sql wordpress
SQL
0 vote311 views1 answer
Including parameters in OPENQUERY
SQL
0 vote339 views1 answer
Mysql multiple primary keys
SQL
39 votes387 views5 answers
Sql drop column
SQL