ID: 13195 Comment by: nicolas dot karageuzian at clubmed dot com Reported By: martinrosenauer at hotmail dot com Status: Open Bug Type: Feature/Change Request Operating System: Linux PHP Version: 4.0.6 New Comment:
Hi, we tried the following example : <?php $proc_qry = "CALL CM.CLIBROS(? , ? , ?)"; $dbconn = dbconnect(); $proc_stmt = odbc_prepare($dbconn,$proc_qry); $codFon = 0; $codPYC = "010"; $codRet = ""; $values = array ($codFon,$codPYC,$codRet); $result = odbc_execute($proc_stmt,$values) ; while(odbc_fetch_row($result)){ for($i=1;$i<=odbc_num_fields($result);$i++){ echo "colonne ".i." : ".odbc_result($result,$i); } //for } //while the third parameter of CLIBROS stored procedure is an output parameter. PHP reported this error : [error] PHP Warning: odbc_execute(): SQL error: [IBM][CLI Driver] CLI0005W Option value changed. SQLSTATE=01S02, SQL state 01S02 in SQLExecute in testPRS.php on line 31 we didn't find how to register an output parameter for the statement. Previous Comments: ------------------------------------------------------------------------ [2001-09-07 11:23:23] martinrosenauer at hotmail dot com As of now the odbc-wrapper, for example used with DB2 databases, support calling stored procedures. It supports IN parameters used with stored procedures as well, but not OUT parameters (meaning you can get parameters returned to PHP when calling a stored procedure). This is for example possible when using Perl and DBI (against DB2). The method there that enables it is called Bind (where you bind a var to an out parameter). Unfortunately this method is not available as odbc_bind. If this is by any chance possible I'd be more than happy! I had a brief dialog with Frank Kromann ([EMAIL PROTECTED]), who was involved with the ODBC wrapper implementation and he confirmed that a binding or OUT parameter support was already there. Best regards and thanks a mill, Martin Jacobsen, Denmark ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=13195&edit=1