楼主说的报表是指哪种报表? 我做了个小测试供楼主参考,可以知道这个包被哪些Database Object引用了:DROP PACKAGE test_2; CREATE PACKAGE TEST_2 AS FUNCTION len(p_str IN VARCHAR2) RETURN NUMBER; END;DROP PACKAGE BODY TEST_2; CREATE PACKAGE BODY TEST_2 AS FUNCTION len(p_str IN VARCHAR2) RETURN NUMBER AS BEGIN RETURN length(p_str); END; END;DROP FUNCTION ret_len; CREATE FUNCTION RET_LEN(p_str VARCHAR2) RETURN NUMBER AS BEGIN RETURN test_2.len(p_str); END;SELECT NAME,TYPE,REFERENCED_OWNER,REFERENCED_NAME FROM user_dependencies WHERE referenced_name='TEST_2'; NAME TYPE REFERENCED_OWNER REFERENCED_NAME -------------------- ------------------ -------------------- -------------------- TEST_2 PACKAGE BODY SH TEST_2 RET_LEN FUNCTION SH TEST_2
我做了个小测试供楼主参考,可以知道这个包被哪些Database Object引用了:DROP PACKAGE test_2;
CREATE PACKAGE TEST_2 AS
FUNCTION len(p_str IN VARCHAR2) RETURN NUMBER;
END;DROP PACKAGE BODY TEST_2;
CREATE PACKAGE BODY TEST_2 AS
FUNCTION len(p_str IN VARCHAR2)
RETURN NUMBER
AS
BEGIN
RETURN length(p_str);
END;
END;DROP FUNCTION ret_len;
CREATE FUNCTION RET_LEN(p_str VARCHAR2)
RETURN NUMBER
AS
BEGIN
RETURN test_2.len(p_str);
END;SELECT NAME,TYPE,REFERENCED_OWNER,REFERENCED_NAME
FROM user_dependencies WHERE referenced_name='TEST_2';
NAME TYPE REFERENCED_OWNER REFERENCED_NAME
-------------------- ------------------ -------------------- --------------------
TEST_2 PACKAGE BODY SH TEST_2
RET_LEN FUNCTION SH TEST_2