springboot:mybatis-plus调用Oracle存储过程,参数为集合
oracle需要执行的语句创建新数组类型CREATE OR REPLACE TYPE tables_array AS VARRAY(50000) OF VARCHAR2(64);Oracle 存储过程PROCEDURE PRO_ZRZ_IDS_BY_BDCDYHS (v_bdcdyhs IN tables_array,v_cursor OUT sys_refcursor)ASv_sql varchar2(9000);BEGIN v_sql := 'SELECT T.ID FROM QJ
原创
2020-07-31 14:50:01 ·
2604 阅读 ·
0 评论