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.

 View Only
Expand all | Collapse all

Difference between select selectOne Record configured operations in Oracle dbadapter

  • 1.  Difference between select selectOne Record configured operations in Oracle dbadapter

    Posted Sun June 08, 2003 03:36 PM

    Can any body explain me the exact difference between these two operations “SELECT” & “SELECT(One Record)”.


    #broker
    #webMethods
    #Integration-Server-and-ESB
    #Universal-Messaging-Broker


  • 2.  RE: Difference between select selectOne Record configured operations in Oracle dbadapter

    Posted Mon June 28, 2004 07:30 PM

    The JDBC adapter documentation says :
    “Use the SELECT (One Record) operation to configure a SELECT operation that returns only one record.”
    I assume that it is the same for Oracle adapter.
    Therefore, operation output will be a single record/struct instead of an array.

    M.


    #webMethods
    #broker
    #Universal-Messaging-Broker
    #Integration-Server-and-ESB