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

Pass String Array as input to Java Stored Procedure

  • 1.  Pass String Array as input to Java Stored Procedure

    Posted Wed March 01, 2006 01:45 PM

    Hi,
    Could you please help sort out my issue with JDBC data types. I have a requirement wherein i need to pass a string array (java.lang.String) to a stored procedure as input. The data type java.lang.String is not directly supported. Could you please suggest an alternative mechanism?

    Best Regards
    Sivaraj Lenin


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


  • 2.  RE: Pass String Array as input to Java Stored Procedure

    Posted Wed March 01, 2006 01:48 PM

    How is this variable defined in your stored procedure? What DBMS are you using?

    Mark


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


  • 3.  RE: Pass String Array as input to Java Stored Procedure

    Posted Wed March 01, 2006 01:58 PM

    Hi
    Thanks for your quick reply. Please find attached the java stored procedure code. In my flow service, I’ve a string list variable. I’ve set the input type as java.lang.Object for the JDBC adapter service which invokes this stored procedure. Please advise.

    Cheers


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


Related Content