Re: Cursor Question

I think REPLACE is an ORACLE reserved word and by calling your procedure 'replace' you are confusing the compiler, try calling your procedure by a different name ??

Pete

Manfred Woellner <manfred_woellner_sc_at_my-deja.com> wrote in message news: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 Sun Jun 06 1999 - 14:09:14 CEST