This content has been marked as final. Show 2 replies
I wrote for you the relations between the tables so you will get the incoming/outgoing data details:
select xd.document_id , xd.DOCUMENT_TYPE,DBMS_LOB.GETLENGTH(xd.document)
from xml_document xd,
where xd.document_id = ip.payload_key
and ip.instance_id = ci.id
and ci.ecid = 'xxxxxxxxxxxxxxxxxxxxx1111112222222333333'