Bug in dbms_metadata.get_xml ?

From: <g.entelmann_at_t-online.de>
Date: 6 May 2004 02:38:35 -0700
Message-ID: <390eb482.0405060138.1c733f77@posting.google.com>

Hello,

I have a case in Oracle9i where dbms_metadata.get_xml does not work corectly.

When I try to extract the metadata for one of my views I get (by executing "select dbms_metadata.get_xml('VIEW', 'WAAGEN')from dual"):

<?xml version="1.0"?>
<ROWSET>
 <ROW>
  <VIEW_T>

   <VERS_MAJOR>1</VERS_MAJOR>
   <VERS_MINOR>0 </VERS_MINOR>
   <OBJ_NUM>31271</OBJ_NUM>
   <SCHEMA_OBJ>

<OBJ_NUM>31271</OBJ_NUM>
<OWNER_NUM>65</OWNER_NUM>
<OWNER_NAME>VSAM_YEOMAN</OWNER_NAME>
<NAME>WAAGEN</NAME>
<NAMESPACE>1</NAMESPACE>
<TYPE_NUM>4</TYPE_NUM>
<TYPE_NAME>VIEW</TYPE_NAME>
<CTIME>19.04.2004 10:29:09</CTIME>
<MTIME>29.04.2004 10:25:19</MTIME>
<STIME>29.04.2004 10:25:19</STIME>
<STATUS>1</STATUS>
<FLAGS>0</FLAGS>
<SPARE1>6</SPARE1>
<SPARE2>65535</SPARE2>

   </SCHEMA_OBJ>
   <AUDIT_VAL>--------------------------------</AUDIT_VAL>
   <COLS>11</COLS>
   <INTCOLS>11</INTCOLS>
   <PROPERTY>0</PROPERTY>
   <FLAGS>0</FLAGS>
   <TEXTLENGTH>128</TEXTLENGTH>
   <TEXT>SELECT NETNAME, DEVICE, ID, BEZEICHNUNG, NUMMER, ORT, NK,

FREIGABE, SPERRTEXT1, SPERRTEXT2, TYP
FROM PERIPHERIE
WHERE TYP &lt; 256INTCOL_NUM>1</INTCOL_NUM>

     <SEGCOL_NUM>1</SEGCOL_NUM>
     <PROPERTY>0</PROPERTY>
     <NAME>NETNAME</NAME>
     <TYPE_NUM>1</TYPE_NUM>

</COL_LIST_ITEM>

  .... (rest left away)

It is obvious, that the element <TEXT> is not closed ...

Is this a known issue, or am i using an older buggy version of the package ?

Many thanks in advance
  Gerrit

PS: I was using SQL*Plus with long = 9999999 and linesize = 10000 Received on Thu May 06 2004 - 04:38:35 CDT