Hi,

I have a stored procedure with 1 IN parameter and 2 OUT parameters as per below code.

CREATE OR REPLACE FUNCTION proc1(client TEXT, is_ok OUT TEXT, error_details OUT TEXT)
RETURNS record AS $$
DECLARE
matters_rec RECORD;
l_client_details CHAR(200);
l_numrec INTEGER;
BEGIN
if (client = 'ABC') then
is_ok := 'Y';
error_details := 'No Error';
else
is_ok := 'N';
error_details := 'This is an Error';
end-if;

END;
$$ language plpgsql;

Is it possible to call the above procedure from within an action in OX?

Thanks and regards,
Irshad