title: How to select Oracle DB sdo_geometry in php
body: <p>My server is nginx and I use adodb5 to manage the connexion to the Oracle DB.</p>
  
  <p>This db query returns rows in a SQL software like SQLDevelopper but I don't know how to make it work in my case.</p>
  
  <pre><code>$sql = "SELECT geom_object FROM geom_table";
  </code></pre>
  
  <p>Whereas this other request works :</p>
  
  <pre><code>$sql = "SELECT id FROM geom_table";
  </code></pre>
  
  <p>My connecting code is correct because all my queries return some data, except those involving SDO_GEOMETRY.</p>
  
  <pre><code>include ("adodb5/adodb-exceptions.inc.php"); 
  include ("adodb5/adodb-errorhandler.inc.php"); 
  include ("adodb5/adodb.inc.php");
  
  try {   
      $db = NewADOConnection("oci8"); 
      $db-&gt;Connect($sid, $user, $password);
      $db-&gt;SetFetchMode(ADODB_FETCH_ASSOC);
  } catch (exception $e) { 
      var_dump($e); 
      adodb_backtrace($e-&gt;gettrace());
      exit;
  }
  
  try 
  { 
      $ret = $db-&gt;GetArray($sql);
      print count($ret);
  } 
  
  catch (exception $e) 
  { 
      print $e-&gt;msg; 
      exit;
  }
  </code></pre>