#37136 [Opn->Bgs]: oci_bind_by_name resulted with "Only variables can be passed by reference"

ID: 37136 Updated by: tony2001@php.net Reported By: minh dot huynh at bowker dot com -Status: Open +Status: Bogus -Bug Type: Oracle related +Bug Type: OCI8 related Operating System: win32 PHP Version: 5.1.2 New Comment: Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php http://php.net/oci_bind_by_name Previous Comments: ------------------------------------------------------------------------ [2006-04-19 14:14:10] minh dot huynh at bowker dot com Description: ------------ I run php5.1.2, Apache2, using IIS Win32. It gives "Only variables can be passed by reference" when I try oci_bind_by_name. Reproduce code: --------------- <?php $conn = oci_connect("userid","password","ora1"); $sSQL = "select * from rcl.rcl_item where rcl_item_uid = :myid"; $Statement = oci_parse($conn, $sSQL); oci_bind_by_name($Statement, ':myid', 10,8); oci_execute($Statement); oci_free_statement($Statement); oci_close($conn); ?> Expected result: ---------------- nothing, but I got fatal error: Only variables can be passed by reference Actual result: -------------- When I didn't use oci_bind_by_name it worked. I was able to print out column names and values. I think it's a bug. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37136&edit=1