Cannot Compile ST_GEOMETRY in DEBUG mode

628
0
04-17-2014 07:02 AM
Highlighted
New Contributor
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
Reply
0 Kudos
0 Replies