When you create a table in SQL Navigator with one of it's columns of datatype SDO_GEOMETRY, you are unable to carry out certain actions on the table such as;
1. Describe
2. Edit
3. Edit Triggers
4. Create Views on
WORKAROUND:
Include the schema name MDSYS when defining the column name as per the below example:
CREATE TABLE Table1(
ID Integer NOT NULL,
ADDRESS Varchar2(100),
PLACE MDSYS.SDO_Geometry,
POSTCODE Varchar2(30) )
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center