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 vote215 views3 answers
How to assign custom id in mysql
SQL
4 votes187 views1 answer
Wilayah indonesia database
SQL
0 vote207 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
1 vote209 views3 answers
Alter schema sql server
SQL
1 vote209 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
25 votes195 views6 answers
Modify column name in mysql
SQL
0 vote202 views1 answer
Psql store procedure-return multiple table values
SQL
6 votes204 views1 answer
Phpmyadmin password root
SQL
0 vote201 views1 answer
Call procedure in wordpress
SQL
0 vote228 views1 answer
SQL joins in python
SQL