I've to use stored procedure in RPGLE program. My code is
CallP OESP_PORD_001(IPAT#:OPNXT#:PRJUK)
I get error name or indicator not defined...I checked the library, parameters and everything are in place....Am I calling the SP with the right syntax?
I tried to then change this whole using SQL...execute statement however my program is RPGLE and not SQLRPGLE...
Please help
-NG
yes i defined it 2nd way and now it works....thanks...
well i'm trying to understand this whole naming convention ....
the stored procedure has name OESP_PORD_001,
when this is stored in the DB library after compilation(?) it receives the object name OESP_00001......
when i define the prototype i have to use this object name as the parameter.
D UOPDD Pr Extname(OESP_00001)
....
C Callp UOPDD(Parm1:Parm2:Parm3)
now the program compiles but this throws error - More parameters were passed in the prototyped call than are allowed.
when i checked the SP, it has 3 input parameters.........then where it is going wrong....
--NG
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 2  Replies