webMethods

 View Only
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