Re: Bug in dbms_metadata.get_xml ?

"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message news:<G7Jnc.30850$TT.25719_at_news-server.bigpond.net.au>...
> <g.entelmann_at_t-online.de> wrote in message
> news:390eb482.0405092317.74d2fd82_at_posting.google.com...
> > "Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message
> news:<jZKmc.25526$TT.24971_at_news-server.bigpond.net.au>...
> SNIP
> > > 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
> >
> >
> > Hello Douglas,
> >
> > thank you very much for your answer. I am using 9.2.0.1 on WinXP Pro
> > SP1 also
> > and still can reproduce my error.
> > You can use this statements:
> > CREATE TABLE "PERIPHERIE2"
> > ( "ID" NUMBER(10,0) NOT NULL PRIMARY KEY,
> > "THE_NETNAME" VARCHAR2(35),
> > "THE_DEVICE" VARCHAR2(16),
> > "BEZEICHNUNG" VARCHAR2(35),
> > "NUMMER" NUMBER(10,0),
> > "ORT" VARCHAR2(1),
> > "NK" NUMBER(10,0),
> > "FREIGABE" NUMBER(10,0),
> > "SPERRTEXT1" VARCHAR2(35),
> > "SPERRTEXT2" VARCHAR2(35),
> > "TYP" NUMBER(10,0),
> > "C_USER" VARCHAR2(10),
> > "M_USER" VARCHAR2(10),
> > "CREATD" DATE,
> > "MODIFD" DATE,
> > "ID_EXTERN" VARCHAR2(16)
> > );
> >
> > CREATE VIEW "WAAGEN2" AS
> > SELECT THE_NETNAME, THE_DEVICE, ID, BEZEICHNUNG, NUMMER, ORT, NK,
> > FREIGABE, SPERRTEXT1, SPERRTEXT2, TYP
> > FROM PERIPHERIE2
> > WHERE TYP < 256;
> >
> >
> > When executing "select dbms_metadata.get_xml('VIEW', 'WAAGEN2') from
> > dual;"
> > i still get:
> > ...
> > <TEXTLENGTH>137</TEXTLENGTH>
> > <TEXT>SELECT THE_NETNAME, THE_DEVICE, ID, BEZEICHNUNG, NUMMER, ORT,
> > NK, FREIGABE, SPERRTEXT1, SPERRTEXT2, TYP
> > FROM PERIPHERIE2
> > WHERE TYP &lt; 256 <INTCOL_NUM>1</INTCOL_NUM>
> > <SEGCOL_NUM>1</SEGCOL_NUM>
> > <PROPERTY>0</PROPERTY>
> > ...
> >
> > Can you verify this on your System ??
> >
> > Very many thanks in advance
> > Gerrit
>
> Gerrit,
>
> I am still unable to reproduce the error. My output, in part, is:
> ...
> <AUDIT_VAL>--------------------------------</AUDIT_VAL>
> <COLS>11</COLS>
> <INTCOLS>11</INTCOLS>
> <PROPERTY>0</PROPERTY>
> <FLAGS>0</FLAGS>
> <TEXTLENGTH>136</TEXTLENGTH>
> <TEXT>SELECT THE_NETNAME, THE_DEVICE, ID, BEZEICHNUNG, NUMMER, ORT, NK,
> FREIGABE, SPERRTEXT1, SPERRTEXT2, TYP
> FROM PERIPHERIE2
> WHERE TYP &lt; 256</TEXT>
> <COL_LIST>
> <COL_LIST_ITEM>
> <OBJ_NUM>32479</OBJ_NUM>
> <COL_NUM>1</COL_NUM>
> <INTCOL_NUM>1</INTCOL_NUM>
> <SEGCOL_NUM>1</SEGCOL_NUM>
> ...
>
> Somehow I managed to get one (1) character less in my definition of the
> view: I have 136 characters while you have 137 characters.
>
> Douglas Hawthorne

Douglas,

thank you very much for your support! I will try to reinstall dbms_metadata,
since my problem remains. I tested my problem on another server in my company and this server, as yours, has no problems generating the xml.

Gerrit Received on Tue May 11 2004 - 01:58:36 CDT