Re: Remote SQL Stored-procedure call - Not getting updated INOUTparameter value

It turns out to be a coding issue on my part. Thanks.

"Hockchai Lim" <lim.hock-chai@xxxxxxxxxxxxxxx> wrote in message news:<mailman.644.1353364893.10847.rpg400-l@xxxxxxxxxxxx>...
Couldn't quite able to figure this out. In my RPG program, it performs a disconnect from current system and then connect to a remote system and then calls a stored-procedure on the remote system. The last three parameters contain error info that the stored-procedure is supposed to pass back. For some reason, they are not being pass back/updated.

Below are relevant code in my RPG program:
exec sql disconnect current;
exec sql connect to Mcbell4;
exec sql call lrResetLoginProcessRequestSP
(:piuserid, :piRequestId, :piChgPwdAlso,:pinewEncPwd,
:pinewEncPwdLn,:pinewEncPwdVc,:pinewASCEBC, 'Y',
:piErrFlag, :piErrID, :piErrMsg);



Below is the create procedure statement for this stored-procedure.
create procedure
lrResetLoginProcessRequestSP(
inout piUserId Varchar(256),
inout piRequestID Varchar(256),
inout piChgPwdAlso Char(1),
inout pinewEncPwd Binary(256),
inout pinewEncPwdLn int,
inout pinewEncPwdVc Binary(16),
inout pinewASCEBC Char(1),
in piForcePwd char(1),
inout piErrFlag char(1),
inout piErrID char(7),
inout piErrMsg char(255)
)

language RPGLE

program type sub

external name SVLRRP(LRRESETLOGINPROCESSREQUEST)

not deterministic

parameter style general;
----------