Here's the situation :
I've XML " data " (not as file ) stored as CLOB in a table,
I need to parse this data and extract the attributes from that data using PL/SQL.
Any suggestions.. Please post !!
So You have XML (file) content in a CLOB field :) Use XMLType and XML DB functions, etc...
XMLType API is at
and also check it out at
and some samples are at