Database Utilities (MOSC)

MOSC Banner

ORA-01706 with XMLTABLE and parsing images (BLOB)

I got "ORA-01706: user function result value was too large" with my sql statement below in PL/SQL Developer. Please advise how to get images (blob) out of XMLType column.

Thank you so much.


select c.num_dln,

    v.num_image,

    v.image_type,

    v.img_image

 from jdbcxml t

 cross apply xmltable ('TRANSFER'

    passing t.xmldata

    columns num_dln varchar2(9) path 'NUM_DLN',

        image   XMLTYPE   path 'IMAGE'

 ) c

  cross apply xmltable ('IMAGE'

    passing c.image

    columns num_image varchar2(4) path 'NUM_IMAGE',

        image_type varchar2(10) path 'IMAGE_TYPE',

        img_image blob  path 'IMG_IMAGE'

 ) v

Wenyen Chang

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center