#48410 [Opn]: Using database link throws unrecognized date warning
| From: | krastin dot georgiev at gmail dot com | Date: | Wed, 27 May 2009 23:07:05 +0000 |
| Subject: | #48410 [Opn]: Using database link throws unrecognized date warning | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-137814@lists.php.net to get a copy of this message | ||
ID: 48410
User updated by: krastin dot georgiev at gmail dot com
Reported By: krastin dot georgiev at gmail dot com
Status: Open
Bug Type: OCI8 related
Operating System: Linux (ALL)
PHP Version: 5.2.9
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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_REP@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