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 vote181 views1 answer
Rails run native ssql query
SQL
7 votes184 views4 answers
What is my mysql version
SQL
1 vote181 views1 answer
Mysql current time
SQL
18 votes179 views3 answers
Mysql add column with default value
SQL
4 votes178 views3 answers
Oracle sql first day of quarter
SQL
1 vote198 views2 answers
Logical operators in sql
SQL
0 vote211 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
8 votes177 views3 answers
Postgresql connection string c#
SQL
34 votes232 views6 answers
Install mysql client ubuntu
SQL
18 votes186 views4 answers
Mysql current date between two dates
SQL