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

Error on executing Oracle SP with JDBC Adapter

  • 1.  Error on executing Oracle SP with JDBC Adapter

    Posted Mon April 21, 2003 04:16 PM

    Hello,

    I’m working with Oracle DB version 8i.
    I’m trying to execute an SP with OUT parameters type BOOLEAN. By using Developer tool, the configuration of the adapter service we find out that, in the “Parameter” tab configuration does not exist this kind of JDBC Parameter type (BOOLEAN). So have tried some types and the error message that I always receive is:

    “Wrong number or types of arguments in call to…”

    Anyone used Oracle BOOLEAN types with JDBC Adapter?

    Someone can help me understanding why this happens?

    Thanks

    Hugo


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


  • 2.  RE: Error on executing Oracle SP with JDBC Adapter

    Posted Mon December 08, 2003 05:15 PM

    Hugo,

    The Oracle JDBC driver doesn’t support the passing of BOOLEAN parameters to PL/SQL procedures. Check out the Oracle8i JDBC Developer’s Guide and Reference (Chapter 19 - Common problems - Boolean parameters in PL/SQL Stored procedures).

    The article also contains a work around.


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