ORA-02063: preceding line error while using dblink
711794Jul 14 2009 — edited Jul 14 2009CREATE OR REPLACE PROCEDURE TEST AS
BEGIN
DECLARE
v_circle VARCHAR(10);
CURSOR c1 IS SELECT file_number,SUBSTR(file_name,INSTR(file_name,'.',1,2)+1,LENGTH(file_name)) AS ftm_id FROM TABLE1 WHERE trim(a.start_TIME) = trim(SYSDATE-1);
BEGIN
FOR r1 IN c1 LOOP
BEGIN
dbms_output.put_line(r1.file_number);
SELECT CIRCLE INTO v_circle FROM METHODLOG@ictprd_to_amdica a,METHODINFO_INTEC_DASHBORD@ictprd_to_amdica b
WHERE a.METHOD=b.method_name AND FTMID=r1.ftm_id;
UPDATE TABLE1 SET CIRCLE=v_circle WHERE FILE_number=r1.file_number;
COMMIT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
END;
END LOOP;
END;
END;