Notification to read XML from an Oracle table

I’m running webMethods 7.1.2.

I want to use a JDBC Adapter Notification to read a large XML document contained in an Oracle CLOB field, convert this to a document (using xmlStringToNode and xmlNodeToDocument), then publish this document.

I just discovered that JDBC adapter notifications do not support CLOB fields.

I’m thinking that I’ll follow the JDBC Adapter Notification with a JDBC SelectSQL adapter service to read the record again to extract the XML data stored in the CLOB field, then do DeleteSQL to delete the record.

Is there a simpler way to accomplish this?

Thank you,

Scott