Stored procedure using ODBC

[PhilippeDJ]

We use ODBC to connect to our IBM I5 server, I would like to get stored procedures working in php, can anyone post an example ?

An example where I get a parameter returned and not using any PEAR procedures.

This is the code to create the stored procedure :

CREATE PROCEDURE PPLIBS/GETNEXTNUMBER(IN KEY CHAR (1 ), INOUT   

NUMBER DEC (9 , 0), INOUT ERROR CHAR (1 )) LANGUAGE COBOL NOT   

DETERMINISTIC CONTAINS SQL EXTERNAL NAME PPLIBS/AUTNBB PARAMETER
STYLE GENERAL

[PhilippeDJ]

This works :

$conn = openODBCconnection('I5','ODBCuser','password);
$stmt = odbc_prepare($conn, "CALL PPLIBS.GETNEXTNUMBER(?,?,?)");
$parms = array("T",0," ");
odbc_execute($stmt, &$parms);

But the second parameter is also an output parameter how do I get the result ?