Question on the IF clause

From: Brandon Duncan <BDuncan_at_PIETECHNET.com>
Date: Tue, 12 Oct 1999 17:12:13 -0400
Message-ID: <7u08be$cqd$1@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 - 16:12:13 CDT