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 vote207 views1 answer
Mysql not defined
SQL
0 vote196 views1 answer
Why mysql is used?
SQL
0 vote241 views1 answer
SQL Cut part string
SQL
1 vote212 views3 answers
Postgresql connect to database
SQL
1 vote207 views1 answer
Oracle sql first day of year
SQL
0 vote205 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote223 views1 answer
Select all same column value in sql
SQL
2 votes206 views1 answer
Docker run postgres locally
SQL
0 vote197 views1 answer
Mysql bash execute sql file
SQL
0 vote217 views1 answer
Mysql range of dates overlap
SQL