KETTLE 无法找到ORACLE 中创建的 存储过程。
这样子可以解决。是由于存储过程必须 一个传入参数,否则KETTLE会看不到见。
改写一下存储过程即可。
改写前
CREATE OR REPLACE PROCEDURE CREATE_ALI_RECSYSDATA is
改写后。
CREATE OR REPLACE PROCEDURE CREATE_ALI_RECSYSDATA (startpoint in number) is
2021/03/15 14:04:39 - 27 - Commit on database connection [27]
2021/03/15 14:04:39 - EXEC PROCE RECSYSDATA.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Because of an error, this step can't continue:
2021/03/15 14:04:39 - EXEC PROCE RECSYSDATA.0 - Unable to call procedure
2021/03/15 14:04:39 - EXEC PROCE RECSYSDATA.0 - ORA-06550: line 1, column 13:
2021/03/15 14:04:39 - EXEC PROCE RECSYSDATA.0 - PLS-00222: no function with name 'CREATE_ALI_RECSYSDATA' exists in this scope
2021/03/15 14:04:39 - EXEC PROCE RECSYSDATA.0 - ORA-06550: line 1, column 7:
2021/03/15 14:04:39 - EXEC PROCE RECSYSDATA.0 - PL/SQL: Statement ignored
可以正常调用和找到了explorer 也可以看到了。