Oracle实现自定义字典功能封装

 CREATE OR REPLACE Package ZLXA_Dictionary_Service Is

    
  
    
 	--此处的过程名和参数名称、数量、类型不能更改
    
  
    
 	--中联西安
    
 	--王大聖 iwangshengfeng@163.com wsfeng@zlsoft.cn
    
 	--2021-06-08
    
 	--实现Oracle字典功能
    
  
    
 	/* *****需要执行Type定义
    
 Create Or Replace Type ZLDictionary Force As Object(key Varchar2(4000), value Varchar2(4000));
    
 /
    
   15. --执行后
    
 Create Or Replace Public Synonym ZLDictionary For SBHIS.ZLDictionary;
    
 Grant Execute On ZLDictionary To Public;
    
   19. Create Or Replace Type ZLDictArray As Table Of ZLDictionary;
    
 /
    
   22. --执行后