Re: Cursor Question

Replace is a reserved word. If the procedure must be named that, then you will need to put it in "REPLACE" and the double-quotes will need to be used whenever you reference it.

Kenny Gump

Manfred Woellner wrote in message <7jde5i$r11$1_at_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 Mon Jun 07 1999 - 18:19:57 CEST