#19687 [NEW]: ociexecute calling procedure with boolean out parameter
| From: | yk at teamlog dot com | Date: | Tue, 01 Oct 2002 11:54:18 +0000 |
| Subject: | #19687 [NEW]: ociexecute calling procedure with boolean out parameter | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-20913@lists.php.net to get a copy of this message | ||
From: yk@teamlog.com
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