Hi,
I have a Stored Proc created as:

Code:
CREATE OR REPLACE   PROCEDURE           COMP_RECORDS
    IS
    l_query          VARCHAR2 (10000) := '';
    
    CURSOR TBL1
    IS
    SELECT TABLE_NAME, COLUMN_NAME FROM COLS_TO_COMP WHERE TABLE_NAME='SECMASTER_HISTORY';
    TBL1_REC              APP_DEVELOPMENT.COLS_TO_COMP%rowtype;
    
    BEGIN
...