Re: error: PLS-00201: identifier 'UPDATEXML' must be declared

On Jan 26, 11:48 am, "Gertjan" <gvhei..._at_xs4all.nl> wrote:
> Hi,
>
> i'm a newby to PL/SQL programming and Oracle, so this is probably a
> real dumb question, but i can't find the solution in the newsgroups ...
>
> When i load the code below i get the following error:
>
> PLS-00201: identifier 'UPDATEXML' must be declared
>
> the function i'm loading is (in 10g , but the code should also work in
> 9i):
>
> CREATE OR REPLACE FUNCTION getXMLValue (udfname IN tFBVelden.naam%TYPE)
> return varchar2
> IS
> udfid tFBVelden.VeldNummer%TYPE;
> clobval Clob;
> xmlval XMLType;
> val varchar2(200);
> BEGIN
> udfid := fieldToUDF(udfname);
> SELECT UDFValues INTO clobval FROM tProcessen WHERE procesnummer =
> 'B0009';
> xmlval := XMLType.CreateXML(clobval);
> val :=
> xmlval.extract('/lokaleMetaData/metadataWaarde/text()').getStringVal;
> DBMS_OUTPUT.PUT_LINE ('old val = ' || val);
> xmlval := UPDATEXML(xmlval, '/lokaleMetaData/metadataWaarde/text()',
> '25');
> val :=
> xmlval.extract('/lokaleMetaData/metadataWaarde/text()').getStringVal;
> DBMS_OUTPUT.PUT_LINE ('new val = ' || val);
> RETURN val;
> END;
>
> apparently the complier can't find UPDATEXML. Any idea how to sove this?

Actually, this is a FAQ. So your assertion 'I can't find the solution in the newsgroup' probably should be read as 'I didn't search at all' Because if I search on PLS-00201 within less than a minute I retrieve one of my own responses

http://groups.google.com/group/comp.databases.oracle.misc/browse_frm/thread/1e05257dcb1f47b9/5e0bb1b68eafca00?lnk=gst&q=pls-00201&rnum=5#5e0bb1b68eafca00

-- 
Sybrand Bakker
Senior Oracle DBA