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.
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
Stephen HughesBroadcom Support