Layer7 API Management

Expand all | Collapse all

How to execute an Oracle stored procedure that returns a cursor and two varchar in the CA API Gateway?

  • 1.  How to execute an Oracle stored procedure that returns a cursor and two varchar in the CA API Gateway?

    Posted Feb 15, 2018 02:32 PM

    When trying to run from Gateway I get the following error: The query test failed: The IN or OUT parameter is missing in the index :: 1 However, SQL Developer does not generate any errors. The connection to the database is correct and has no problems.



  • 2.  Re: How to execute an Oracle stored procedure that returns a cursor and two varchar in the CA API Gateway?

    Broadcom Employee
    Posted Dec 07, 2018 08:37 PM

    Good evening,

     

    Variables should not be declared in the Query along with the print statement. The usage patterns are outlined under the Using Functions and Stored Procedures section Perform JDBC Query Assertion - CA API Gateway - 9.3 - CA Technologies Documentation. Additional examples of how someones used stored procedures for Oracle DB

    API Gateway - Oracle R12 JDBC Connection and Stored Procedure Query Errors 

     

    Sincerely,


    Stephen Hughes
    Broadcom Support