webMethods

webMethods

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

Using Boolean input parameter in SP call || JDBC

  • 1.  Using Boolean input parameter in SP call || JDBC

    Posted Tue September 08, 2020 01:39 AM

    Hi,

    From this post here from 2014, it says ,JDBC has a limitation to treat Boolean as a parameter. Is it still the same?

    Do we still have to create a wrapper StoredProcedure which accepts a Varchar instead of boolean?


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


  • 2.  RE: Using Boolean input parameter in SP call || JDBC

    Posted Wed November 04, 2020 01:55 AM

    Hi Divya,

    As per JDBC Developer’s guide of 11g release 2 (11.2), Oracle JDBC drivers doesn’t support calling arguments or return values of the PL/SQL BOOLEAN type.
    You can check below link for more details.
    https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxref.htm#JJDBC28928

    However, such limitation is not mentioned in JDBC Developer’s guide of 12c release 2 (12.2).

    So, I assume that there is no such limitation with latest oracle JDBC driver.

    Regards
    Anurag


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