Link to home
Start Free TrialLog in
Avatar of pvsbandi
pvsbandiFlag for United States of America

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
);

Open in new window

The error I'm facing is the below:

procedure parameter "io_error_message" is an output parameter but corresponding argument is not writ

Open in new window

Can someone kindly help figure out the fix for it?

Attaching the SP code.


Thank you!EDBSPZ54.sql


ASKER CERTIFIED SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pvsbandi

ASKER

thank you! missed this trivial thing, but thanks again!