#48410 [NEW]: Using database link throws unrecognized date warning
| From: | krastin dot georgiev at gmail dot com | Date: | Wed, 27 May 2009 23:00:58 +0000 |
| Subject: | #48410 [NEW]: Using database link throws unrecognized date warning | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-137811@lists.php.net to get a copy of this message | ||
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_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 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