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

From: Gertjan <gvheijst_at_xs4all.nl>
Date: 26 Jan 2007 02:48:46 -0800
Message-ID: <1169808526.613899.162850@m58g2000cwm.googlegroups.com>

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? Received on Fri Jan 26 2007 - 04:48:46 CST