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 vote115 views1 answer
Set engine to innodb
SQL
4 votes108 views1 answer
Data types in sql
SQL
2 votes95 views2 answers
Oracle create table if not exists
SQL
0 vote106 views1 answer
Convert excel into sqllite db using python
SQL
3 votes117 views2 answers
Oracle apex view logs
SQL
1 vote109 views1 answer
Print all records of table in mysql
SQL
0 vote101 views1 answer
Postgres week number
SQL
0 vote104 views1 answer
Double in sql server example
SQL
0 vote106 views2 answers
Mysql get routine parameter list
SQL
1 vote113 views1 answer
Table valued functions in sql
SQL