Re: Create table in if-statement

Kathinka Diehl <kathinka_at_rrr.de> wrote:
>
> [...]
> begin
> drop table [...]
> execpion
> when table_not_found do nothing
> when others raise_application_error
> create table [...]
> [...]

Sorry, I have looked in my manual, DDL and DCl is not possible inside PL/SQL. A PL/SQL-program could not drop oder create a table.

I you need this, you have to use SQLPlus-scripts. If you need examples for scripts doing this, send me an email, I will send it to you. But just batches for NT.

Regards,
Kathinka Received on Fri Jul 14 2000 - 00:00:00 CDT