Re: Stored procedure call not working

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Nevermind, I was misreading...



On Wed, Jul 29, 2015 at 12:25 PM, Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

> Your "works through RPG" example seems to show a *PGM call not a procedure
> in a *SRVPGM..
>
> Just typo on the post or is that your problem?
>
> On Wed, Jul 29, 2015 at 11:19 AM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
>
> > 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.