bkoren

Cannot Compile ST_GEOMETRY in DEBUG mode

Discussion created by bkoren on Apr 17, 2014
Using an Oracle 11.2 SDE database I am trying to debug a PL/SQL procedure that I've written. The procedure's code reads a table (in a coworkers schema) that has a column with a ST_GEOMETRY data type. It reads this column and writes the value into one of my tables (in my logged on schema) that also contains an ST_GEOMETRY column. When running the procedure the code seems to execute ok.

But when attempting to run the procedure using TOAD's interactive debugger the following error occurs.

ALTER TYPE SDE.ST_GEOMETRY COMPILE DEBUG
Error at line 2
ORA-01031: insufficient privileges

Can someone tell me the priviledges that my account needs to compile a debug version of ST_GEOMETRY?

Or might there be some other issue that displays this error?

Thanks, Brad

Outcomes