topic Cannot Compile ST_GEOMETRY in DEBUG mode in Data Management Questions https://community.esri.com/t5/data-management-questions/cannot-compile-st-geometry-in-debug-mode/m-p/298712#M17115 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>But when attempting to run the procedure using TOAD's interactive debugger the following error occurs.</SPAN><BR /><BR /><SPAN>ALTER TYPE SDE.ST_GEOMETRY COMPILE DEBUG</SPAN><BR /><SPAN>Error at line 2</SPAN><BR /><SPAN>ORA-01031: insufficient privileges</SPAN><BR /><BR /><SPAN>Can someone tell me the priviledges that my account needs to compile a debug version of ST_GEOMETRY? </SPAN><BR /><BR /><SPAN>Or might there be some other issue that displays this error?</SPAN><BR /><BR /><SPAN>Thanks, Brad</SPAN></BODY></HTML> Thu, 17 Apr 2014 14:02:48 GMT BradKoren 2014-04-17T14:02:48Z Cannot Compile ST_GEOMETRY in DEBUG mode https://community.esri.com/t5/data-management-questions/cannot-compile-st-geometry-in-debug-mode/m-p/298712#M17115 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>But when attempting to run the procedure using TOAD's interactive debugger the following error occurs.</SPAN><BR /><BR /><SPAN>ALTER TYPE SDE.ST_GEOMETRY COMPILE DEBUG</SPAN><BR /><SPAN>Error at line 2</SPAN><BR /><SPAN>ORA-01031: insufficient privileges</SPAN><BR /><BR /><SPAN>Can someone tell me the priviledges that my account needs to compile a debug version of ST_GEOMETRY? </SPAN><BR /><BR /><SPAN>Or might there be some other issue that displays this error?</SPAN><BR /><BR /><SPAN>Thanks, Brad</SPAN></BODY></HTML> Thu, 17 Apr 2014 14:02:48 GMT https://community.esri.com/t5/data-management-questions/cannot-compile-st-geometry-in-debug-mode/m-p/298712#M17115 BradKoren 2014-04-17T14:02:48Z