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

  • 1.  how to call procedure with dynamicSQL adapter?

    Posted Mon August 26, 2013 09:31 AM

    I need to call pl\sql procedure with dynamicSQL jdbc adapter. Any help? DB procedure below:

    create or replace
    PROCEDURE TESTPROCEDURE1(var1 in VARCHAR2, var2 out VARCHAR2) AS
    BEGIN
    var2:=‘aaa’;
    END TESTPROCEDURE1;


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


  • 2.  RE: how to call procedure with dynamicSQL adapter?

    Posted Mon August 26, 2013 11:00 AM

    Please use the search functionality on this section with the keyword dynamicSQL and you see various results and take the syntax from there:

    HTH,
    RMG


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


  • 3.  RE: how to call procedure with dynamicSQL adapter?

    Posted Mon August 26, 2013 11:45 AM

    i haven’t found an answer…


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


  • 4.  RE: how to call procedure with dynamicSQL adapter?

    Posted Mon August 26, 2013 01:09 PM

    Why do you want to use DynamicSQL instead of StoredProcedure?
    From what you are showing, it’s perfect to call it using StoredProcedure type.


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


  • 5.  RE: how to call procedure with dynamicSQL adapter?

    Posted Mon August 26, 2013 01:23 PM

    OK…Are you not able to use with stored procedure with signature template?

    HTH,
    RMG


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


  • 6.  RE: how to call procedure with dynamicSQL adapter?

    Posted Tue August 27, 2013 07:15 AM

    This case is related to my another problem generic JdbcAdapter for stored procedures - webMethods - Software AG Tech Community & Forums

    No one try to call procedure from dynamicSql or customSql?


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


Related Content