向Oracle中传入数组批量执行SQL语句

accp_33505 28 0 PDF 2020-12-22 04:12:34

1、首先用PL/SQL创建package 1 create or replace package excuteBatchOperate 2 as 3 type sqlStr_Array is table of varchar2(1000) index by binary_integer; 4 procedure excuteBulkData(sqlStr in sqlStr_Array); 5 end excuteBatchOperate; 2、在packagebody内创建存储过程 1 create or replace package body excuteBatc

用户评论
请输入评论内容
评分:
暂无评论