17,086
社区成员
发帖
与我相关
我的任务
分享
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