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
Back to discussions
Expand all | Collapse all

PLSQL TABLE data type for adapter service

  • 1.  PLSQL TABLE data type for adapter service

    Posted 06/03/03 03:25 PM

    I need to call an oracle stored procedure which returns a PL/SQL TABLE data type (OUT parameter). In the parameter tab of the adapter service, I selected “OTHER” as the JDBC type and “java.lang.Object” as the java type for this parameter. It displays an “Invalid Column type” exception when I run this adapter service.

    How do I get Table type in my service. My requirement is to return an array of strings from Oracle stored procedure. Any help will be appreciated.


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


Related Content