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

Reply via email to