Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: error: PLS-00201: identifier 'UPDATEXML' must be declared
Gertjan schrieb:
> Hi Maxim, > > My version is 10g, but the script i write should work on 9i as well, so > i want to restrict myself to solutions that are documented for 9i (R2).
> related to priviliges, but i can't reallt figure out how... > > Gertjan > > On 26 jan, 14:09, Maxim Demenko <mdeme..._at_arcor.de> wrote:
I don't think, it depends on privileges. Here a testcase with minimum privileges where i can't reproduce your issue. You should better check (or consult your dba) , whether xml support is installed properly and whether all objects on your database are in valid state.
SQL> select * from v$version;
BANNER
SQL> create user test_xml identified by test_xml default tablespace users;
User created.
SQL> alter user test_xml quota 1m on users;
User altered.
SQL> grant create session,create table to test_xml;
Grant succeeded.
SQL> connect test_xml/test_xml
Connected.
SQL> create table txml(id number,xml_col xmltype);
Table created.
SQL> insert into txml values(1,xmltype('<row>Scott</row>'));
1 row created.
SQL> select * from txml;
ID XML_COL
---------- -------------------------------------------------- 1 <row>Scott</row>
SQL> update txml set xml_col = updatexml(xml_col,'/row/text()','King') where id=1;
1 row updated.
SQL> select * from txml;
ID XML_COL
---------- -------------------------------------------------- 1 <row>King</row>
Best regards
Maxim Received on Fri Jan 26 2007 - 09:06:50 CST