Library list of your Ops Nav ?
I guess you already checked Ops Nav parameter type matches ?
Not sure, can't be a problem with case-sensitivity ?
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Wednesday, July 29, 2015 9:19 AM
To: RPG programming on the IBM i / System i
Subject: Stored procedure call not working
I have a defined a stored procedure using a service program
CREATE PROCEDURE DEVIILIB/TESTITRANSFER(IN ID_NUMBER BIGINT ) LANGUAGE RPGLE NOT DETERMINISTIC NO SQL EXTERNAL NAME 'DEVIILIB/ITTEST(TESTPROCEDURE)'
PARAMETER STYLE GENERAL
I went to IBM Redbooks and this is exactly the way they show it being done and using Ops Nav to test.
I can call this stored procedure through an RPG program without a hitch but when I try to call from Ops Nav or from a C# program it fails with a message saying
Program ITTEST in library DEVIILIB not found. Obviously the service program is there because I works through RPG
CALL DEVIILIB.TESTITRANSFER(1)
from Ops Nav.
I know it is seeing the stored procedure definition because it says it can't find the program or service program.
I have checked the service program and the public has change authority which includes execute.
Have I got an IBM bug of some kind? I have used stored procedures implemented with service programs for years.
Any ideas?
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
