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_...@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
