Re: Bug in dbms_metadata.get

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Mon, 10 May 2004 10:50:14 GMT
Message-ID: <G7Jnc.30850$TT.25719@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 = 'EMP'</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 < 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 < 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 Received on Mon May 10 2004 - 05:50:14 CDT

Re: Bug in dbms_metadata.get_xml ?