Mybatis+Oracle将对象集合传给存储过程DEMO
这几天公司需要使用到存储过程,且存储过程参数为对象集合,在网上搜了很久的资料,终于了解了大概,这里做个记录。
1.create oracle custom type
create or replace TYPE OBJ_DEMO AS OBJECT
(
DEMO_ATTR varchar2(30),
DEMO_VALUE varchar2(80)
);
create or replace TYPE OBJ_DEMO_ARRAY AS
TABLE OF OBJ_DEMO;
create or replace TYPE OBJ_DEMO_LABEL_ARRAY AS TABLE OF OBJ_DEMO_ARRAY;
2.create procedure
CREATE OR REPLACE PROCEDURE PROC_DEMO_QUERY(
OBJ_DEMO_LABEL_ARRAY IN OBJ_DEMO_LABEL_ARRAY,
START_DATE IN VARCHAR2,
END_DATE IN VARCHAR2,
RESULT_OUT OUT SYS_REFCURSOR
)
IS
date_format varchar2(