Re: Max number of parameters with PHP calling SP

[Aaron Bartell <aaronbartell@xxxxxxxxxxxxxxx>]

Is it a SP that wrappers an RPG program/service program?  I don't know if
that would cause a difference but it could.  I don't believe SQL SPs are
limited like PCML (Program Call Markup Language) is.

Not much of an answer from me, but maybe will spark some ideas.

Aaron Bartell
www.MowYourLawn.com/blog
www.OpenRPGUI.com
www.SoftwareSavesLives.com


On Wed, Jun 19, 2013 at 11:30 AM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

> Does anyone know if there's a max number of parameters when calling a
> stored procedure from PHP?  I'm calling the SP from PHP with 16 parameters.
>
> The SP exists - I can call it from Navigator with no problem.
>
> I get these messages when calling from PHP:
>
> [19-Jun-2013 16:07:41 UTC] PHP Warning:  db2_execute() [<a
> href='function.db2-execute'>function.db2-execute</a>]: Value Not Bound
> in /www/zendsvr/htdocs/mPos_Dev/mike/model/Orders.php on line 784
> [19-Jun-2013 16:07:41 UTC] PHP Warning:  db2_execute() [<a
> href='function.db2-execute'>function.db2-execute</a>]: Binding Error 3
> in /www/zendsvr/htdocs/mPos_Dev/mike/model/Orders.php on line 784
>
> My other calls to SP's work fine - this is a new call.
>
> Thanks!
> --
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.