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
  • 1.  Component 'GET_info' must be declared

    Posted Wed February 07, 2024 06:18 AM

    Hi every one,
    I face this issue once try to run the adapter service in software ag 10.15
    any idea ?

    com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service ******************** with connection *****************************
    [ADA.1.316] Cannot execute the SQL statement “call GET_info( ?, ?)”. "
    (65000/6550) ORA-06550: line 1, column 13:
    PLS-00302: component ‘GET_info’ must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    "
    ORA-06550: line 1, column 13:
    PLS-00302: component ‘GET_info’ must be declared
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    #webMethods-cloud
    #webMethods
    #webMethods-io-B2B
    #B2B-Integration


  • 2.  RE: Component 'GET_info' must be declared

    Posted Wed February 07, 2024 06:52 AM

    Hi,

    please provide more details about your requirement.

    JDBC Adapter version with applied Fixes
    Any Fixes applied to IS/ART?

    I assume that you are trying to invoke a StoredProcedure on your database.
    Was the StoredProcedure deployed to the database?

    Regards,
    Holger


    #webMethods-cloud
    #B2B-Integration
    #webMethods
    #webMethods-io-B2B


  • 3.  RE: Component 'GET_info' must be declared

    Posted Wed February 07, 2024 07:54 AM

    Hi Holger,

    Yes exactly I am trying to invoke stored procedure
    JDBC version is 10.3
    And yes the StoredProcedure deployed to the database
    I was invoke SPs many times successfully but for this I don’t know what happen! (it is new connection added)


    #webMethods-io-B2B
    #webMethods-cloud
    #B2B-Integration
    #webMethods


  • 4.  RE: Component 'GET_info' must be declared

    Posted Wed February 07, 2024 08:36 AM


  • 5.  RE: Component 'GET_info' must be declared

    Posted Wed February 07, 2024 12:39 PM

    Hi,

    can you share a screenshot of the adapter serivce invoking the SP and of the SP itself (signature would be sufficient)?

    Regards,
    Holger


    #webMethods
    #webMethods-io-B2B
    #webMethods-cloud
    #B2B-Integration