package里面的procedure和function的信息保存在哪个数据字典表里面

解决方案 »

  1.   


    select * from all_objects where object_type = 'FUNCTION';
      

  2.   


    SELECT * FROM all_arguments
    WHERE object_name LIKE 'MW711%';
    OWNER        OBJECT_NAME          PACKAGE_NAME OBJECT_ID OVERLOAD SUBPROGRAM_ID ARGUMENT_NAME                
    ------------ -------------------- ------------ --------- -------- ------------- -----------------------------
    MS0001211DED MW711P01_LRUECKSTAND MW711K01     63406     (Null)   11            PI_LIEFERRUECKSTAND_BIS_DATUM
    MS0001211DED MW711P01_LRUECKSTAND MW711K01     63406     (Null)   11            PI_GEBI_NR                   
    MS0001211DED MW711P01_LRUECKSTAND MW711K01     63406     (Null)   11            PI_VAR                       
    MS0001211DED MW711P01_LRUECKSTAND MW711K01     63406     (Null)   11            PI_ART_NR                    
    MS0001211DED MW711P01_LRUECKSTAND MW711K01     63406     (Null)   11            (Null)                       
    MS0001211DED MW711P01_NAE_LIEFDAT MW711K01     63406     (Null)   10            KZ_DRUCK                     
    MS0001211DED MW711P01_NAE_LIEFDAT MW711K01     63406     (Null)   10            ANZ_GEBI_VAR_BEST_MAX        
    MS0001211DED MW711P01_NAE_LIEFDAT MW711K01     63406     (Null)   10            LIEFERORT_ID                 
    MS0001211DED MW711P01_NAE_LIEFDAT MW711K01     63406     (Null)   10            UR6_SRT