用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是存储过程页的标签,找到存储过程后,右键==>"
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...