Cursor Question

From: Manfred Woellner <manfred_woellner_sc_at_my-deja.com>
Date: Sun, 06 Jun 1999 09:12:54 GMT
Message-ID: <7jde2l$r0v$1@nnrp1.deja.com>

Greetings,
can anyone tell me why I get this Errormsg. (see Procedure on the bottom)
PLS-00306 wrong number or types of arguments in call 'REPLACE' TIA
Manfred

CREATE OR REPLACE
PROCEDURE replace AS

v_txt_ref CDI_TEXT2.txt_ref%TYPE;
v_txt_text CDI_TEXT2.txt_text%TYPE;

CURSOR v_cursor IS SELECT txt_ref, txt_text FROM CDI_TEXT2; BEGIN
  OPEN v_cursor;
  LOOP
    FETCH v_cursor INTO v_txt_ref, v_txt_text;     EXIT WHEN v_cursor%NOTFOUND;
    REPLACE(v_txt_text, '#Marion#', '#M#');     UPDATE CDI_TEXT2 SET txt_text = v_txt_text

        WHERE txt_ref = v_txt_ref;
  END LOOP;
  CLOSE v_cursor;
END; Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Jun 06 1999 - 04:12:54 CDT