[cx-oracle-users] cx_Oracle and SDO_GEOMETRY

[Jani T. <re...@gm...>]

Hi,

I was trying out bleeding edge version of cx_Oracle and tried to create 
SDO_GEOMETRY objects.

For some reason in my environments I had to always prefix SDO_GEOMETRY 
with MDSYS schema name. Is there reason that plain SDO_GEOMETRY doesn't 
work?

Traceback I get:

(django-tests)jtiai@jns42-l:~/code/django-tests/cx_oracle/samples$ 
python InsertGeometry.py
Traceback (most recent call last):
   File "InsertGeometry.py", line 13, in <module>
     typeObj = connection.gettype("SDO_GEOMETRY")
cx_Oracle.DatabaseError: ORA-04043: object SDO_GEOMETRY does not exist

-- 

Jani Tiainen