Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-02063: preceding line error while using dblink

711794Jul 14 2009 — edited Jul 14 2009
CREATE 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;

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 11 2009
Added on Jul 14 2009
4 comments
4,342 views