Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create table in if-statement

Re: Create table in if-statement

From: Kathinka Diehl <kathinka_at_rrr.de>
Date: 2000/07/14
Message-ID: <8kmvhg$2re4q$1@ID-6887.news.cis.dfn.de>#1/1

<poluha_at_my-deja.com> schrieb:

>

> I'm doing this in a stored procedure. Wouldn't an error like this
> generate an exception and thus interrupt the procedure?

Catch your exception using:

[...]
begin
 drop table [...]
execpion
 when table_not_found do nothing
 when others raise_application_error
create table [...]
[...]

If you don't catch it, it will be given to the upper program.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US