Help: Error Missing Keyword in line 15

From: Fred Wilson <faNOWilsonSPAM_at_comcast.net>
Date: Thu, 21 Sep 2006 18:55:06 -0400
Message-ID: <pMCdnZ6wk9u-hY7YnZ2dnUVZ_sGdnZ2d@comcast.com>

If anyone can enlighten me?

The error is reporting for the EXECUTE IMMEDIATE LINE below

I am going to post another message with a error from this same code but gives me Error Number Missing at line 22.

Thank you.

CURSOR CUR_LOC IS
SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME='EVT_CD'; OLD_EV_CD VARCHAR(20) :='136'; T_NAME VARCHAR(40); num_of_rec number;

BEGIN DBMS_OUTPUT.ENABLE (200000); DBMS_OUTPUT.PUT_LINE ('EVENT CODE IS: ' || OLD_EV_CD); OPEN CUR_LOC; LOOP FETCH CUR_LOC INTO T_NAME; EXIT WHEN CUR_LOC%NOTFOUND;

    DBMS_OUTPUT.PUT_LINE ('+++++++++++++++++++++++  ' || T_NAME);

EXECUTE IMMEDIATE '(SELECT COUNT(*) into NUM_OF_REC FROM ' || T_NAME || ' WHERE EVT_CD = ' || OLD_EV_CD || ')'; DBMS_OUTPUT.PUT_LINE ('NUMBER OF RECORDS IN THIS TABLE: ' || NUM_OF_REC); END LOOP; CLOSE CUR_LOC; END; Received on Thu Sep 21 2006 - 17:55:06 CDT