|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2017-05-25 03:33 UTC] sixd@php.net
-Status: Open
+Status: Closed
-Assigned To:
+Assigned To: sixd
[2017-05-25 03:33 UTC] sixd@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Oct 26 23:00:02 2025 UTC |
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