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 vote322 views1 answer
Su: Authentication failure mysql
SQL
0 vote340 views1 answer
Compare subqueries oracle
SQL
0 vote326 views1 answer
Mac os zsh: command not found: mysql
SQL
1 vote328 views1 answer
Postgres get month name from date
SQL
9 votes337 views6 answers
Check constraint in sql
SQL
0 vote321 views1 answer
Mysql select where field is a value
SQL
0 vote314 views1 answer
Postgres 11 add primary key
SQL
8 votes301 views2 answers
Phpmyadmin password
SQL
2 votes326 views1 answer
How to delete view in sql
SQL
1 vote333 views2 answers
Postgresql get difference in hours between two dates
SQL