Issue with Cursor in the Stored Procedure. Please help as soon as possible!

[sayan13]

Hi,
I have a Stored Proc created as:

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                
        For tbl1_rec in tbl1
        loop
                l_query := 'INSERT INTO TEST2 SELECT a.'||TBL1_REC.COLUMN_NAME || 'FROM security.secmaster_history a where a.security_alias=18330 and a.src=60254'; 
                 EXECUTE IMMEDIATE l_query;
                COMMIT;
        end loop;
    END;

when i am running this i am getting an exception as ora-00923: From keyword not found where expected.
Can anyone help please...its urgent!

[rski]

Looks like you missed space between FROM

Should be

' FROM security.secmaster_history a where a.security_alias=18330 and