I have a procedure inside of a service program, how can i create a stored procedure for the below Procedure.
Dcl-Pi ProcedureName Varchar(2000);
InputStr Varchar(2000) CONST;
OutStrLen Uns(5) OPTIONS(*NOPASS) CONST;
End-Pi;
I created Stored procedure for the procedure as below, but When i call this procedure it throwing error(Data type mismatch)
My Stored procedure:
CREATE PROCEDURE STOLIB.STOPRO3 (
IN NEW_PARAMETER BINARY(2000) )
LANGUAGE RPGLE
SPECIFIC STOLIB.STOPRO3
NOT DETERMINISTIC
MODIFIES SQL DATA
CALLED ON NULL INPUT
EXTERNAL NAME 'STOLIB/SRVPGM(ProcedureName)'
PARAMETER STYLE SQL ;
What i am missing while creating this Stored Procedure?
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…