package里面的procedure和function的信息保存在哪个数据字典表里面
package里面的procedure和function的信息保存在哪个数据字典表里面
[解决办法]
SELECT * FROM all_arguments
WHERE object_name LIKE 'MW711%';
OWNER OBJECT_NAME PACKAGE_NAMEOBJECT_IDOVERLOADSUBPROGRAM_IDARGUMENT_NAME
-------------------------------------------------------------------------------------------------------
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_LIEFERRUECKSTAND_BIS_DATUM
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_GEBI_NR
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_VAR
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 PI_ART_NR
MS0001211DEDMW711P01_LRUECKSTANDMW711K01 63406 (Null) 11 (Null)
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 KZ_DRUCK
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 ANZ_GEBI_VAR_BEST_MAX
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 LIEFERORT_ID
MS0001211DEDMW711P01_NAE_LIEFDATMW711K01 63406 (Null) 10 UR6_SRT
