From: [EMAIL PROTECTED] Operating system: win 2k PHP version: 4.2.1 PHP Bug Type: OCI8 related Bug description: ociexecute calling procedure with boolean out parameter
PROBLEM OCIEXECUTE WITH BOOLEAN OUTPUT PARAMETERS: The call to the following stored procedure (oracle 8.1.7) from php4.2.1 (as ampache module) does not work with a boolean parameter. It works fine however when I change boolean to NUMBER. /************ the procedure in PL SQL ********************/ PROCEDURE testit(arg1 IN OUT BOOLEAN) IS BEGIN arg1:=TRUE; END; /*********************************************************/ /************ the call from PHP **************************/ $stmt = OCIParse($connector->_connectionID, "BEGIN testit(:arg1); END;"); OCIBindByName($stmt,":arg1",$ret,10); OCIExecute($stmt); OCIFreeStatement($stmt); /*********************************************************/ /************ the warning in french :-) ******************/ Warning: OCIStmtExecute: ORA-06550: Ligne 1, colonne 7 : PLS-00306: num�ro ou types d'arguments erron�s dans appel � 'TESTIT' ORA-06550: Ligne 1, colonne 7 : PL/SQL: Statement ignored in d:\apache\htdocs\iac\test.php on line 32 false (traduction of the warning : wrong argument number or type) /*********************************************************/ -- Edit bug report at http://bugs.php.net/?id=19687&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19687&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19687&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19687&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19687&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19687&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19687&r=support Expected behavior: http://bugs.php.net/fix.php?id=19687&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19687&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19687&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19687&r=globals
