8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for XMLTYPE Datatype

Sandeep said...

The DBMS_XMLGEN package which is used to create the XML from the queries has got a major bug in it of whose status in 9i has been not solved. If the XML to be generated has got a number of children i.e. upto level 7 or more and the query is called in a loop then there is a memory leak in the Database which causes the query to fail.
I would say that currently the XML and Database implementation is in a nascent and lots needs to be done before it can acutally be used in heavy duty applications that rely on XMLs

Brendan said...

Useless article!

Tim... said...

Brandan: Thanks for the constructive criticism!



Anu said...

The XML API getNumVal() doesnt seem to work for me.. I had to use getNumberVal()..


Tim... said...


The article doesn't contain the getNumVal() method. I can only assume you are trying to do something different using the manual I linked to.

In 9i the method was called getNumVal(), while in 10g it was renamed to getNumberVal().

I'm guessing you are using 10g. The moral of this story is, use the manual that comes with your version :)



Ratnaker said...

Good Article

Muhammad said...

Great Article thanks

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.