IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  How to convert from CLOB reader to XML

    Posted 06/07/13 12:34 PM

    Hi,
    I have an Oracle SP that return me a CLOB, how can I convert it to xml or text?

    Thank oyu


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: How to convert from CLOB reader to XML

    Posted 06/07/13 02:39 PM

    For SQL Server CLOB XML in the select template the JDBC Type is LONGVARCHAR AND output field type is lang.String this will output XML data in the pipeline.

    Can try the similar with Oracle?

    HTH,
    RMG


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods