title: Get length of oracle.sql.array
body: <p>On an Oracle DB I have a table with SDO_GEOMETRY objects. I would like to query the database for those polygons with less than x edges. In theory this would be easy with a query like</p>
  
  <pre><code>SELECT * FROM myTable t WHERE LENGTH(t.geometry.sdo_ordinates) &lt; x
  </code></pre>
  
  <p>Obviously the LENGTH funtion is defined for char and the type of 
  <code>t.geometry.sdo_ordinates</code> is oracle.sql.ARRAY so that doesn't work. Shouldn't there be a trivial way to SELECT the length or an array in Oracle? Somehow I'm unable to get the syntax right.</p>
  
  <p>PS: I kind of solved my search with the following query, still the original questerion remains, isn't there an array size/length function?</p>
  
  <pre><code>SELECT * FROM myTable t WHERE LENGTH(t.geomety.Get_WKT()) &lt; (x * c)
  </code></pre>