用toad时,不用DBA权限就可以调试存储过程的方法
1.
CREATE ROLE TOAD_PLSQL_DEV_SENIOR NOT IDENTIFIED;
GRANT DEBUG ANY PROCEDURE TO TOAD_PLSQL_DEV_SENIOR;
GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO TOAD_PLSQL_DEV_SENIOR;
GRANT DEBUG CONNECT SESSION TO TOAD_PLSQL_DEV_SENIOR;
GRANT TOAD_PLSQL_DEV_SENIOR TO user_name;

2. 用user_name登录toad后就可以调试,如果还不能,则将resource也授予该用户

<br />用toad时,不用DBA权限就可以调试存储过程的方法<br />1. <br />CREATE ROLE TOAD_PLSQL_DEV_SENIOR NOT IDENTIFIED;<br />GRANT DEBUG ANY PROCEDURE TO TOAD_PLSQL_DEV_SENIOR;<br />GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP TO TOAD_PLSQL_DEV_SENIOR;<br />GRANT DEBUG CONNECT SESSION T
通过可视化工具(如PL/SQL Developer、 Oracle SQL Developer)调试 Oracle 的存储过程时,如果遇到如下错误信息: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_ DEBUG _JDWP", line 68 ORA-06512: at line 1 This session req
Toad for SQL Server 3.2 该工具可进行存储过程的调试 请用迅雷http://www.jhxyey.net/Soft/UF361dxx/Toad%20for%20SQL%20Server%203.2.0.rar Programability是存储过程页的标签,找到存储过程后,右键==&gt;" Debug "即可;... DROP JAVA SOURCE NEWXZXT."Hello"; CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED NEWXZXT."Hello" as import java.lang.*; public class Hello public stat...