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 vote332 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote338 views1 answer
Fill up postgres db
SQL
7 votes325 views3 answers
Sql get last inserted row
SQL
0 vote359 views1 answer
Timestamp(0) postgresql
SQL
0 vote305 views1 answer
Mysql timeout 30 seconds
SQL
8 votes324 views1 answer
Oracle add month
SQL
1 vote355 views1 answer
Sql current timestamp
SQL
0 vote340 views1 answer
Sql convert datetime to year
SQL
38 votes340 views4 answers
Count sql
SQL
0 vote324 views1 answer
Sql row number in result set
SQL