Re: Question on the IF clause

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 12 Oct 1999 20:17:02 -0400
Message-ID: <mcQM3.11809$UG5.665544@typ11.nn.bcandid.com>

To use DDL statements in PL/SQL you should take a look at the DBMS_SQL package that came with Oracle.

Van

Brandon Duncan <BDuncan_at_PIETECHNET.com> wrote in message news:7u08be$cqd$1_at_autumn.news.rcn.net...
> To anyone who knows the answer:
> Why does the following SQL Block fail on line 8? Are there only certain
> statements which can fall within an IF clause? If, so, what are they?
>
> 1 DECLARE
> 2 llTableExists NUMBER(11,0);
>
> 3 BEGIN
> 4 SELECT INTO llTableExists TABLE_NAME FROM ALL_TABLES WHERE
> TABLE_NAME = 'Table1' AND 5 OWNER = 'OWNER1';
> 6
> 7 IF llTableExists >=1 THEN
> 8 DROP TABLE Table1;
> 9 END IF;
> 10 END;
>
> Thanks,
>
> Brandon
>
>
Received on Tue Oct 12 1999 - 19:17:02 CDT