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

2 votes382 views1 answer
Orcale index size
SQL
18 votes329 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
-1 vote379 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote377 views1 answer
Kill mysqld_safe process mariadb
SQL
3 votes351 views1 answer
Oracle wait
SQL
0 vote357 views1 answer
Multiple tricky query in sql server
SQL
0 vote383 views1 answer
Psql show db
SQL
0 vote404 views1 answer
Check if mysql db is used
SQL
2 votes353 views2 answers
How to get capital letter first in sql
SQL
0 vote361 views1 answer
How to put value in parameters in mysqldataadapter
SQL