[size=large]给Function增加调试权限
GRANT debug any procedure, debug connect session TO 用户;
GRANT debug any function, debug connect session TO 用户;
grant debug connect session to 用户
ALTER FUNCTION DAY COMPILE DEBUG
去除函数DAY的调试信息,执行ALTER FUNCTION DAY COMPILE。
上面两条就是在PLSQL中点右键添加或者去除调试信息
查看某对象是否处于调试状态:
SELECT debuginfo
FROM SYS.ALL_PROBE_OBJECTS PO
WHERE PO.OWNER = ' 用户'
AND PO.OBJECT_NAME = 'FN_T_TEST'
AND PO.OBJECT_TYPE = 'FUNCTION';[/size]
GRANT debug any procedure, debug connect session TO 用户;
GRANT debug any function, debug connect session TO 用户;
grant debug connect session to 用户
ALTER FUNCTION DAY COMPILE DEBUG
去除函数DAY的调试信息,执行ALTER FUNCTION DAY COMPILE。
上面两条就是在PLSQL中点右键添加或者去除调试信息
查看某对象是否处于调试状态:
SELECT debuginfo
FROM SYS.ALL_PROBE_OBJECTS PO
WHERE PO.OWNER = ' 用户'
AND PO.OBJECT_NAME = 'FN_T_TEST'
AND PO.OBJECT_TYPE = 'FUNCTION';[/size]