Bug #74647 [Opn->Csd]: Specific Type generates fetch error

Edit report at https://bugs.php.net/bug.php?id=74647&edit=1 ID: 74647 Updated by: sixd@php.net Reported by: uli dot staerk at globalways dot net Summary: Specific Type generates fetch error -Status: Open +Status: Closed Type: Bug Package: PDO OCI Operating System: Linux PHP Version: 7.0.19 -Assigned To: +Assigned To: sixd Block user comment: N Private report: N New Comment: This is expected. Use the kind of solutions given in the "Using Oracle Locator for Spatial Mapping" section of http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html (Or use Python cx_Oracle 5.3+) There are no short term plans to add support, so I'll close this bug. But the feature request won't be forgotten. Previous Comments: ------------------------------------------------------------------------ [2017-05-24 14:11:31] uli dot staerk at globalways dot net 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 this bug report at https://bugs.php.net/bug.php?id=74647&edit=1