Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Bug in dbms_metadata.get_xml ?

Re: Bug in dbms_metadata.get_xml ?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Fri, 07 May 2004 12:06:39 GMT
Message-ID: <jZKmc.25526$TT.24971@news-server.bigpond.net.au>


<g.entelmann_at_t-online.de> wrote in message news:390eb482.0405060138.1c733f77_at_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

Gerrit,

I tried a similar thing on 10.1.0.2 and 9.2.0.1 on WinXP Pro SP1 and I could not reproduce your error. My output in part is from iSQL*Plus: <TEXTLENGTH>284< /TEXTLENGTH><TEXT> SELECT object_ name, subobject_name, object _id, data_object_id, object_ type, created, last_ddl_time , timestamp, status, temporary, generated, secondary FROM user_objects WHERE object_name = &apos;EMP&apos;</TEXT>

Douglas Hawthorne Received on Fri May 07 2004 - 07:06:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US