Bug #51196 [Com]: SQLT_INT or OCI_B_INT not binding correctly

From: Date: Wed, 03 Mar 2010 13:12:13 +0000
Subject: Bug #51196 [Com]: SQLT_INT or OCI_B_INT not binding correctly
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-148214@lists.php.net to get a copy of this message 
Edit report at http://bugs.php.net/bug.php?id=51196&edit=1

 ID:               51196
 Comment by:       
 Reported by:      joel at layers dot com
 Summary:          SQLT_INT or OCI_B_INT not binding correctly
 Status:           Open
 Type:             Bug
 Package:          OCI8 related
 Operating System: linux 2.6.21.7-2.fc8xen
 PHP Version:      5.3.1

 New Comment:

As a test, try this PLSQL function with the SQLT_INT or OCI_B_INT bind
types...

CREATE OR REPLACE FUNCTION FUNCTION1 RETURN NUMBER AS 
BEGIN
  RETURN 234;
END FUNCTION1;


Previous Comments:
------------------------------------------------------------------------
[2010-03-03 13:53:51] joel at layers dot com

Description:
------------
When trying to bind the return value of a function as SQLT_INT or
OCI_B_INT, the value that is bound upon return shows as
int(-4294964414), where the expected is 2882, in our case.  The oracle
function returns NUMBER data type.

Changing the bind type to SQLT_CHAR resolves the problem.

This worked in php 5.2.11



------------------------------------------------------------------------



-- 
Edit this bug report at http://bugs.php.net/bug.php?id=51196&edit=1

Thread (4 messages)

« previous php.bugs (#148214) next »