EXECUTE IMMEDIATE ON ORACLE 9i

From: nickp <nickp_at_mmcc.co.uk>
Date: 11 Apr 2003 05:45:29 -0700
Message-ID: <81c48a9d.0304110333.64d5affa@posting.google.com>

I'm trying to run the following code via SQLPLUS on ORACLE9i:

DECLARE
NCOUNT NUMBER;
drptbl varchar2 (255);

BEGIN
drptbl := 'DROP TABLE ADDRESS';
SELECT COUNT(*) into NCOUNT FROM USER_TABLES WHERE TABLE_NAME = 'ADDRESS';

  IF NCOUNT = 1 THEN
     EXECUTE IMMEDIATE drptbl;
  END IF; END; AND IT RETURNS THIS ERROR: EXECUTE IMMEDIATE drptbl;

*
ERROR at line 10:
ORA-06550: line 10, column 14:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: := . ( @ % ;

Does anyone know why this might be ?

Cheers Nick Received on Fri Apr 11 2003 - 07:45:29 CDT