SQL Language (MOSC)

MOSC Banner

Unable to retrieve columns from the CLOB datatype

Hi All,
In the custom table, we have several columns. One of these columns is a CLOB type that contains multiple fields in XML format. We are attempting to retrieve these fields using the XMLTABLE function, but the query is not returning the correct data. I have attached a sample of the CLOB column data in XML format.

Could you please review and share inputs on where the syntax might be incorrect, and how to properly extract the required fields.

select source_id,xt.*
from xx_file_details fd
, xmltable('/TEST_WORKER/PERSON_DETAILS/PERSON_REC'
passing XMLTYPE(fd.FILE_CLOB)

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