--定义类型
CREATE OR REPLACE TYPE strIds AS OBJECT (
codeid varchar2(100)
);
--类型转为table
CREATE OR REPLACE TYPE StrIdstab AS TABLE OF strIds;
CREATE OR REPLACE FUNCTION REP_F_GETBSCODEDATASECU_tony(
v_userid varchar2,
v_finYear varchar2,
v_userOrgTab varchar2,
v_codemodelid varchar2,
v_secuFlag varchar2,
v_businesstype varchar2
)
--定义返回管道
RETURN StrIdstab PIPELINED
is
--定义动态游标
TYPE ref_cursor_type IS REF CURSOR;
res_sql ref_cursor_type;
secu_select_sql varchar2(4000 ) ;
secu_sql varchar2(4000 ) ;
--类型
v strIds;
codeid varchar2(100 ) ;
codename varchar2(100 ) ;
levelid varchar2(100 ) ;
superid varchar2(100 ) ;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载