Bug #74647 [NEW]: Specific Type generates fetch error

From: uli dot staerk at globalways dot net Operating system: Linux PHP version: 7.0.19 Package: PDO OCI Bug Type: Bug Bug description:Specific Type generates fetch error Description: ------------ I have a column described as: all_tab_columns.data_type = SDO_GEOMETRY If I try to select this Column, the following error is generated: Error: SQLSTATE[HY000]: General error: 932 OCIStmtFetch: ORA-00932: inconsistent datatypes: expected CHAR got ADT (/usr/local/src/php7.0-7.0.19/ext/pdo_oci/oci_statement.c:497) Test script: --------------- CREATE TABLE "TEST"."ULITEST" ( "GEO_ID" NUMBER(38,0), "GEOMETRIE" "MDSYS"."SDO_GEOMETRY" ); Insert into TEST.ULITEST (GEO_ID,GEOMETRIE) values (3,MDSYS.SDO_GEOMETRY(2001,31467,MDSYS.SDO_POINT_TYPE(3457079.42,5270387.7,null),null,null)); php > $r = $pdo->query("SELECT * FROM TEST.ULITEST"); php > foreach($r as $row) print_r($row); PHP Warning: Uncaught PDOException: SQLSTATE[HY000]: General error: 932 OCIStmtFetch: ORA-00932: inconsistent datatypes: expected CHAR got ADT (/usr/local/src/php7.0-7.0.19/ext/pdo_oci/oci_statement.c:497) in php shell code:1 Stack trace: #0 {main} thrown in php shell code on line 1 Expected result: ---------------- The result should be the same as inserted by the statement. Actual result: -------------- PDOException -- Edit bug report at https://bugs.php.net/bug.php?id=74647&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74647&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74647&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74647&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=74647&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=74647&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=74647&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=74647&r=needscript Try newer version: https://bugs.php.net/fix.php?id=74647&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=74647&r=support Expected behavior: https://bugs.php.net/fix.php?id=74647&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=74647&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=74647&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=74647&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74647&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=74647&r=dst IIS Stability: https://bugs.php.net/fix.php?id=74647&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=74647&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=74647&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=74647&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=74647&r=mysqlcfg