hii
the below procedure compiles fine,
CREATE OR REPLACE PROCEDURE BG.FIND_DUP (EMP_CODE NUMBER,MAIN_EMP_CODE NUMBER) IS
CURSOR C1 IS
SELECT TABLE_NAME FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME ='EMP_CODE'
AND UPPER(TABLE_NAME)<> UPPER('PA_EMP_MERGE');
V_T_NAME VARCHAR2(2000);
RESULT VARCHAR2(1000);
BEGIN
OPEN C1 ;
LOOP
FETCH C1 INTO V_T_NAME;
EXIT WHEN C1%NOTFOUND;
RESULT := 'UPDATE '||V_T_NAME||' SET EMP_CODE='||EMP_CODE||' WHERE EMP_CODE='||MAIN_EMP_CODE||';';
EXECUTE IMMEDIATE RESULT;
END LOOP;
CLOSE C1;
END;
-----------------------------------------------------------------------------------------------------------------------
but when i try to execute it give me
ORA-06550: line 1, column 26:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
-- Im using oracle 10g