OIC stored proc
Content
Hello, I have a simple stored proc in ATP. I have simple OIC integration that takes a Query parameter ( string type ) and maps to the ATP adapter PROCEDURe IN parameter.
Procedure has a OUT parameter I map the value to the OIC response "Result"
Issue - eben though I passing IN parameter why is it ignored in the procedure response ?
If I pass query parameter as abc then I was expecting stored procedure should have returned me Hello abc World
But procedure always returns Hello World. Why is Resulin ignored ?
set serveroutput on;
CREATE OR REPLACE EDITIONABLE PROCEDURE "ADMIN"."GREETINGS" (
0