Cursor Question

From: Manfred Woellner <manfred_woellner_sc_at_my-deja.com>
Date: Sun, 06 Jun 1999 09:14:27 GMT
Message-ID: <7jde5i$r11$1_at_nnrp1.deja.com>

Greetings,
[Quoted] [Quoted] can anyone tell me why I get this Errormsg. (see Procedure on the bottom)
[Quoted] 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;
[Quoted]     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 - 11:14:27 CEST