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