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
