kettle调用存储过程



存储过程pro_create:实现在tb_teacher表中插入一条数据
1.调用不带参数的存储过程
create or replace procedure PRO_create is
begin
  insert into tb_teacher(id,name) values(4,'郑老师');
  commit;
end PRO_create;
---------------------------------------simpledb.ktr--------------------------------------------



---------------------------------------simpledb.kjb--------------------------------------------


双击【Transformation】选择要对应的文件

直接执行job就可以了。

2.调用带in型参数的存储过程
create or replace procedure PRO_create(v_id in number, v_name in string) is
begin
  insert into tb_teacher(id,name) values(v_id,v_name);
  commit;
end PRO_create;

----------------------------------------simpledb.ktr--------------------------------------------



----------------------------------------simpledb.kjb--------------------------------------------


双击【Transformation】选择要对应的文件


点击运行弹出窗口：

查看plsqldev，显示成功插入：

3.调用带in和out型参数的存储过程
create or replace procedure PRO_create(v_id in number, v_name in string,msg out string) is
begin
  insert into tb_teacher(id,name) values(v_id,v_name);
  msg:=v_name;
  dbms_output.put_line(msg);
  commit;
end PRO_create;
----------------------------------------simpledb.ktr--------------------------------------------


----------------------------------------simpledb.kjb--------------------------------------------


双击【Transformation】选择要对应的文件


点击运行弹出窗口：

查看plsqldev，显示成功插入：