pvsbandi
asked on
Error while executing a Stored Procedure in PG
Greetings,
On Postgres 13, I'm encountering an error message when calling a Stored procedure.
The procedure call is:
call edb.edbspz54_update_role_rqst_stus
( 768::INT -- I_APLCTN_USER_ACNT_ID
, 129::INT -- I_ROLE_RQST_ID
, 'A'::CHAR(1) -- I_APRVD_REJECTED_IND
, 'U'::CHAR(1) -- I_APRVR_TYPE
, ' ''6111'''::VARCHAR(200) -- I_APRVD_APLCTN_ROLE_LIST
, NULL::VARCHAR(200) -- I_RJCTN_JSTFCN_TXT
);
The error I'm facing is the below:
procedure parameter "io_error_message" is an output parameter but corresponding argument is not writ
Can someone kindly help figure out the fix for it?
Attaching the SP code.
Thank you!EDBSPZ54.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER