Re: Fwd: Execute Failed with Stored Procedure Call

I'm not sure if it's your problem, but I don't think you should have the
'$' in front of your variable names in the db2_bind_param() functions.

Suspect lines...
db2_bind_param($stmt, 1, "$vendor", DB2_PARAM_IN);
db2_bind_param($stmt, 2, "$model", DB2_PARAM_IN);

Should be...
db2_bind_param($stmt, 1, "vendor", DB2_PARAM_IN);
db2_bind_param($stmt, 2, "model", DB2_PARAM_IN);

http://www.phpbuilder.com/manual/function.db2-bind-param.php

Glenn

On 12/1/2010 1:47 PM, Michael Ryan wrote:

I've cross posted this since it's an RPG/stored procedure question.

Thanks!

---------- Forwarded message ----------
From: Michael Ryan<michaelrtr@xxxxxxxxx>
Date: Wed, Dec 1, 2010 at 1:46 PM
Subject: Execute Failed with Stored Procedure Call
To: Web Enabling the AS400 / iSeries<web400@xxxxxxxxxxxx>


Hi folks -

Could someone help me out with this? I'm trying to call a stored
procedure
from my PHP script. Lots of help from lots of folks, and it's very much
appreciated. I've decided to use the MODS approach. I'm getting an
error on
the db2_execute...here's a link to the PHP code:
http://code.midrange.com/09a32d9a0e.html

I know the connection is being made, and I know the db2_prepare is
successful. I'm passing two parameters to the procedure and expecting an
array (MODS) back. Do I need to specify the array in the db2_prepare
statement?

Here's my CREATE PROCEDURE statement that I executed from STRSQL:

CREATE PROCEDURE INVENTORY/SPR101R(IN pInVnda CHAR ( 5), IN pInMdl
CHAR ( 20)) LANGUAGE RPGLE NOT DETERMINISTIC READS SQL DATA CALLED
ON NULL INPUT EXTERNAL NAME 'NEWSYS/SPR101R' PARAMETER STYLE GENERAL

Here's the salient part of my RPG code:

Exec SQL
Set Result Sets For Return To Client
Array :ReturnDS For :WkRowcount Rows;

This works when I call the procedure from iSeries Navigator.

Thanks!