From: krastin dot georgiev at gmail dot com
Operating system: Linux (ALL)
PHP version: 5.2.9
PHP Bug Type: OCI8 related
Bug description: Using database link throws unrecognized date warning
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 bug report at http://bugs.php.net/?id=48410&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=48410&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=48410&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=48410&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=48410&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=48410&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=48410&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=48410&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=48410&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=48410&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=48410&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=48410&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=48410&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=48410&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=48410&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=48410&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=48410&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=48410&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=48410&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=48410&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=48410&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=48410&r=mysqlcfg
