Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-19011 character string buffer too small oracle

2607268Feb 7 2014 — edited Feb 10 2014

Hello.

I have the following XML:

<Rowset>

  <Row>

    <Code>01</Code>

    <Details>123</Details>

  </Row>

  <Row>

    <Code>03</Code>

    <Details>1233</Details>

  </Row>

  <Row>

    <Code>07</Code>

    <Details>12333</Details>

  </Row>

</Rowset>

I nedd to extract data 1 in sql query in this format:

CodesList

--------------

01,02,03

I'm using th following code:

select RTRIM(XMLAGG(XMLELEMENT(E,t.process_xml || ',')).EXTRACT('Rowset/Row/Code/text()').GETStringVAL(),',') from table1 t

The XML is in clob "process_xml".

But got the error message: ora-19011 character string buffer too small oracle

Help, please.

This post has been answered by odie_63 on Feb 10 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 10 2014
Added on Feb 7 2014
16 comments
24,391 views