\u5728\u770b\u9ad8\u7ea7\u5e94\u7528\u5f00\u53d1\u624b\u518c\u65f6\uff0c\u5728\u5bf9\u8c61\u4f9d\u8d56\u90e8\u5206\uff0c\u6ce8\u610f\u5230\u8fd9\u4e2a\u7ec6\u8282\u3002
\n\u5176\u4ed6\u5bf9\u8c61\u4f9d\u8d56\u5305\u4e2d\u7684\u8fc7\u7a0b\u6216\u51fd\u6570\uff0c\u5982\u679c\u8fd9\u4e2a\u8fc7\u7a0b\u6216\u51fd\u6570\u5728\u5305\u4e2d\u7684\u4f4d\u7f6e\u53d1\u751f\u4e86\u53d8\u5316\uff0c\u90a3\u4e48\u4f9d\u8d56\u5f53\u524d\u8fc7\u7a0b\u6216\u51fd\u6570\u7684\u5bf9\u8c61\u4f1a\u88ab\u7f6e\u4e3aINVALID\u72b6\u6001\u3002<\/p>\n
SQL> CREATE OR REPLACE PACKAGE P_TEST AS\r\n 2 PROCEDURE P1;\r\n 3 FUNCTION F1 RETURN NUMBER;\r\n 4 END;\r\n 5 \/\r\nPackage created.\r\nSQL> CREATE OR REPLACE FUNCTION F2 RETURN NUMBER AS\r\n 2 BEGIN\r\n 3 RETURN P_TEST.F1;\r\n 4 END;\r\n 5 \/\r\nFunction created.\r\nSQL> SELECT OBJECT_NAME, STATUS \r\n 2 FROM USER_OBJECTS\r\n 3 WHERE OBJECT_NAME IN ('P_TEST', 'F2');\r\nOBJECT_NAME STATUS\r\n------------------------------ -------\r\nF2 VALID\r\nP_TEST VALID\r\nSQL> CREATE OR REPLACE PACKAGE P_TEST AS\r\n 2 PROCEDURE P1;\r\n 3 FUNCTION F1 RETURN NUMBER;\r\n 4 PROCEDURE P3;\r\n 5 END;\r\n 6 \/\r\nPackage created.\r\nSQL> SELECT OBJECT_NAME, STATUS\r\n 2 FROM USER_OBJECTS\r\n 3 WHERE OBJECT_NAME IN ('P_TEST', 'F2');\r\nOBJECT_NAME STATUS\r\n------------------------------ -------\r\nF2 VALID\r\nP_TEST VALID\r\nSQL> CREATE OR REPLACE PACKAGE P_TEST AS\r\n 2 PROCEDURE P1;\r\n 3 PROCEDURE P2;\r\n 4 FUNCTION F1 RETURN NUMBER;\r\n 5 PROCEDURE P3;\r\n 6 END;\r\n 7 \/\r\nPackage created.\r\nSQL> SELECT OBJECT_NAME, STATUS\r\n 2 FROM USER_OBJECTS\r\n 3 WHERE OBJECT_NAME IN ('P_TEST', 'F2');\r\nOBJECT_NAME STATUS\r\n------------------------------ -------\r\nF2 INVALID\r\nP_TEST VALID<\/pre>\n\u5982\u679c\u5c06\u65b0\u589e\u8fc7\u7a0b\u7f6e\u4e8e\u5305\u7684\u5c3e\u90e8\uff0c\u5219\u4e0d\u4f1a\u5f71\u54cd\u4f9d\u8d56\u5173\u7cfb\u3002\u800c\u5982\u679c\u5c06\u65b0\u589e\u8fc7\u7a0b\u7f6e\u4e8e\u67d0\u4e9b\u5df2\u6709\u8fc7\u7a0b\u6216\u51fd\u6570\u7684\u524d\u9762\uff0c\u5219\u6240\u6709\u4f9d\u8d56\u8fd9\u4e9b\u8fc7\u7a0b\u6216\u51fd\u6570\u7684\u5bf9\u8c61\u5c06\u88ab\u7f6e\u4e8eINVALID\u72b6\u6001\uff0c\u8fd9\u662f\u7531\u4e8e\u4f9d\u8d56\u5173\u7cfb\u548c\u8fc7\u7a0b\u6216\u51fd\u6570\u5728\u5305\u4e2d\u7684\u4f4d\u7f6e\u6709\u5173\u3002
\n\u4e0d\u8fc7\u8fd9\u79cd\u4f4d\u7f6e\u53ea\u662f\u8fc7\u7a0b\u6216\u51fd\u6570\u7684\u6392\u5e8f\uff0c\u548c\u5177\u4f53\u6240\u5728\u884c\u6570\u65e0\u5173\uff0c\u800c\u4e14\u53ea\u548c\u8fc7\u7a0b\u6216\u51fd\u6570\u6709\u5173\uff0c\u5982\u679c\u65b0\u589e\u53d8\u91cf\u5219\u4e0d\u4f1a\u4ea7\u751f\u5f71\u54cd\uff1a<\/p>\n
SQL> ALTER FUNCTION F2 COMPILE;\r\nFunction altered.\r\nSQL> SELECT OBJECT_NAME, STATUS\r\n 2 FROM USER_OBJECTS\r\n 3 WHERE OBJECT_NAME IN ('P_TEST', 'F2');\r\nOBJECT_NAME STATUS\r\n------------------------------ -------\r\nF2 VALID\r\nP_TEST VALID\r\nSQL> CREATE OR REPLACE PACKAGE P_TEST AS\r\n 2 G_NUM NUMBER;\r\n 3 PROCEDURE P1;\r\n 4 PROCEDURE P2;\r\n 5 FUNCTION F1 RETURN NUMBER;\r\n 6 PROCEDURE P3;\r\n 7 END;\r\n 8 \/\r\nPackage created.\r\nSQL> SELECT OBJECT_NAME, STATUS\r\n 2 FROM USER_OBJECTS\r\n 3 WHERE OBJECT_NAME IN ('P_TEST', 'F2');\r\nOBJECT_NAME STATUS\r\n------------------------------ -------\r\nF2 VALID\r\nP_TEST VALID<\/pre>\n","protected":false},"excerpt":{"rendered":"\u5728\u770b\u9ad8\u7ea7\u5e94\u7528\u5f00\u53d1\u624b\u518c\u65f6\uff0c\u5728\u5bf9\u8c61\u4f9d\u8d56\u90e8\u5206\uff0c\u6ce8\u610f\u5230\u8fd9\u4e2a\u7ec6\u8282\u3002 \u5176\u4ed6\u5bf9\u8c61\u4f9d\u8d56\u5305\u4e2d\u7684\u8fc7\u7a0b\u6216\u51fd\u6570\uff0c\u5982\u679c\u8fd9\u4e2a\u8fc7\u7a0b\u6216\u51fd\u6570\u5728\u5305\u4e2d\u7684\u4f4d\u7f6e\u53d1\u751f\u4e86\u53d8\u5316\uff0c\u90a3\u4e48\u4f9d\u8d56\u5f53\u524d\u8fc7\u7a0b\u6216\u51fd\u6570\u7684\u5bf9\u8c61\u4f1a\u88ab\u7f6e\u4e3aINVALID\u72b6\u6001\u3002 SQL> CREATE OR REPLACE PACKAGE P_TEST AS 2 PROCEDURE P1; 3 FUNCTION F1 RETURN NUMBER; 4 END; 5 \/ Package created. SQL> CREATE OR REPLACE FUNCTION F2 RETURN NUMBER AS 2 BEGIN 3 RETURN P_TEST.F1; 4 END; 5 … Continue reading