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 vote200 views1 answer
Sql count value greater than
SQL
0 vote215 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote195 views2 answers
Zsh: command not found: mysq
SQL
0 vote173 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote219 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
8 votes186 views3 answers
Alter table auto_increment
SQL
3 votes196 views1 answer
Laravel database Using Named Bindings
SQL
0 vote186 views1 answer
Get number of table colums in sql query
SQL
0 vote238 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote176 views1 answer
Duplicate foreign key constraint name
SQL