Re: Max number of parameters with PHP calling SP

Turns out this had nothing to do with number of parameters. Once I
initialized the variables in the db2_bind_param, everything worked. I think
that PHP was passing nulls or 'empty' to the stored procedure, and that's
what was giving me the binding error. I may also have been able to specify
the data type on the db2_bind_param...I'll give that a try too. Thanks!


On Wed, Jun 19, 2013 at 12:39 PM, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:

It *is* an SP that wrappers an RPG service program procedure. (Definition
of what is is. <smile>)


On Wed, Jun 19, 2013 at 12:38 PM, Michael Ryan <michaelrtr@xxxxxxxxx>wrote:

Is *is* an SP that wrappers an RPG service program procedure.


On Wed, Jun 19, 2013 at 12:37 PM, Aaron Bartell <
aaronbartell@xxxxxxxxxxxxxxx> wrote:

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.

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