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 vote157 views1 answer
Mysql utc timestamp
SQL
0 vote135 views1 answer
Call rest api from postgresql
SQL
18 votes154 views6 answers
Laravel form validation
SQL
0 vote202 views1 answer
Mysql collation portugues brasil
SQL
0 vote228 views1 answer
Mysql delete entire row on condition
SQL
33 votes139 views6 answers
Change column name in mysql
SQL
1 vote139 views1 answer
Access the postgres psql
SQL
1 vote133 views1 answer
Local sql server
SQL
2 votes136 views1 answer
Delete all value query
SQL
1 vote142 views2 answers
Postgresql backup and restore globals and data
SQL