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 vote437 views1 answer
Postgres extract number from string
SQL
0 vote372 views1 answer
Provide hardcoded value in the mysql query
SQL
4 votes344 views1 answer
Check database name postgresql
SQL
0 vote383 views1 answer
Select milliseconds mysql
SQL
1 vote385 views1 answer
Set id count mysql
SQL
0 vote381 views4 answers
Restart MySQL
SQL
3 votes366 views2 answers
Find string in stored procedure sql server
SQL
1 vote310 views1 answer
Restart identity postgresql
SQL
0 vote346 views1 answer
Install ms sql server management studio
SQL
0 vote370 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL