Re: Stored procedure call not working

[Charles Wilt <charles.wilt@xxxxxxxxx>]

What's the PI look like for TESTPROCEDURE()?

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

> 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.