ID: 48410 Updated by: s...@php.net Reported By: krastin dot georgiev at gmail dot com -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: Linux (ALL) PHP Version: 5.2.9 New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Due to the volume of reports we can not explain in detail here why your report is not a bug. The support channels will be able to provide an explanation for you. Thank you for your interest in PHP. ------------- The error message is from the communication between the source and destination databases of the DB link, so PHP OCI8 is unlikely to be the issue. Check the query in SQL*Plus (make sure SQL*Plus use the same Oracle environment settings as the Apache/PHP process). Check the ORA_NLSxx environment variables in effect for the shells starting the DBs were correct. See metalink.oracle.com Note 236320.1 and Note 338832.1 Before updating this bug, follow up on an Oracle-specific forum or with Oracle Support. Previous Comments: ------------------------------------------------------------------------ [2009-05-27 23:07:05] krastin dot georgiev at gmail dot com As sample a table named TY can be created with the following two columns: TY_ID INTEGER TY_NM VARCHAR2(4000) Querying this table across a link will cause the warning. ------------------------------------------------------------------------ [2009-05-27 23:00:58] krastin dot georgiev at gmail dot com Description: ------------ When doing a call across a database link Oracle throws a warning immediately. Compiled using different versions of Oracle instant client and OCI versions. Instant Client versions: 10.2.0.3 10.2.0.4 11.1.0.7.0 OCI versions: 1.2.5 1.3.4 1.3.5 It is important to note that using 1.2.5 on Windows (precompiled) does NOT cause this warning. This is only a problem under Linux. Reproduce code: --------------- <?php $conn = OCILogon("user", "pass", "//192.168.100.15/mysid"); $sql = 'SELECT * FROM dyn_audit_...@remotedb'; $stmt = oci_parse($conn, $sql); $res = oci_execute($stmt); if(is_array($res)) { while ($r = oci_fetch_assoc($res)) { print_r($r); echo "<br>"; } } // end if OCILogoff($conn); ?> Expected result: ---------------- Warning: oci_execute() [function.oci-execute]: ORA-01821: date format not recognized ORA-02063: preceding line from MUREXDM in /home/myself/proc.php on line 7 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=48410&edit=1
