|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-10-10 06:57 UTC] sniper@php.net
[2003-10-10 08:17 UTC] iolaire dot mckinnon at vcint dot com
[2003-10-10 11:46 UTC] sniper@php.net
[2003-10-10 12:57 UTC] iolaire dot mckinnon at vcint dot com
[2003-10-17 03:00 UTC] cjbj at hotmail dot com
[2003-10-28 10:11 UTC] iolaire dot mckinnon at vcint dot com
[2003-12-06 07:12 UTC] thies@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 13:00:01 2025 UTC |
Description: ------------ I'm using Redhat 9, connecting to a Oracle 8.7.1 db. I have the following PHP configuration: './configure' '--with-iodbc' '--with-mssql=/usr/local' '--sysconfdir=/etc' '--with-mysql' '--with-layout=GNU' '--with-gettext' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-config-file-path=/etc/' '--enable-ftp' '--enable-memory-limit' '--enable-xslt' '--with-xslt-sablot' '--with-oracle=/store/OraHome1' '--with-oci8=/store/OraHome1' I connect successfully to the db using OCI8, but when I perform any select, I get an "ORA-03120: two-task conversion routine: integer overflow" error. This occurs even if I am only selecting one row. I can successfully select using the same query with the standard Oracle interface, and with SQLPlus. I also had this problem with php-4.3.2. Reproduce code: --------------- putenv("ORACLE_SID=REP"); putenv("ORACLE_HOME=/store/OraHome1"); putenv("TNS_ADMIN=/store/tnsnames.ora"); OCIInternalDebug(1); $username = "MCKINNONI"; $passwd = "xxxxxxx"; $db="(DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=xxxx)(PORT=1521) ) ) (CONNECT_DATA=(SERVICE_NAME=REP)) )"; $conn = OCILogon($username,$passwd,$db); $stmt = ociparse($conn,"select EMAIL from SpinroomEmailAddresses where EMAIL = 'iolaire.mckinnon@vc int.com'"); ociexecute($stmt); while (ocifetch($stmt)) echo "[".ociresult($stmt,"EMAIL")."]\n"; Expected result: ---------------- [iolaire.mckinnon@vcint.com] Actual result: -------------- OCIDebug: _oci_open_server new conn=0 dname=(DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (HOST=xxxx)(PORT=1521) ) ) (CONNECT_DATA=(SERVICE_NAME=REP)) )<br /> OCIDebug: _oci_open_session new sess=5 user=MCKINNONI<br /> OCIDebug: oci_do_connect: id=6<br /> OCIDebug: oci_parse "select EMAIL from SpinroomEmailAddresses where EMAIL = 'iolaire.mckinnon@vcint.com'" id=7 conn=6<br /> Warning: ociexecute(): OCIStmtExecute: ORA-03120: two-task conversion routine: integer overflow in /var/www/html/oracletest2.php on line 21 OCIDebug: START php_rshutdown_oci<br /> OCIDebug: END php_rshutdown_oci<br />