INFO 调用ORACLE存储过程
1. CMN_1022 WRITER_1_1_1> CMN_1022 Database driver error...
解释:This problem is an orcle 8i defect. It has been resolved in orcle 9i. The workaround is
to run the session in Normal mode. To do so, in Workflow Manager navigate to the Targets window,
and change the Target Load type to Normal.(Workflow 中session 中 Mapping页中,新建时的load Type改为
normal )
2.调用ORACLE 存储过程式是用 begin pro_name; end;
此时会报错:CMN_1022 [begin pro_name FnName: Execute Direct -- [Oracle][ODBC][Ora]ORA-
06550:XXXPLS-00103: 出现符号 "end-of-file"在需要下列之一时::= . ( @ % ;
解译:solution:
I found out by trial and error that Informatica has a problem with linefeeds appearing
inside the anonymous block. Therefore, the correct call is:
BEGIN ITDBOPS.PKG_RCCL_DBOPS.PROC_TRUNCATE_TABLE('STGMKT','STG_CONSUMER_ANALYTICS')/;
END/;
我发现通过试错出的Informatica有一个内部的匿名块出现换行符的问题。
使用 begin pro_name/;end/;
此时完成以上两个原因,应该就可以顺序执行在info 中调用 orcle 存储过程。
info 中调用ORACLE 存储过程
最新推荐文章于 2024-05-06 20:01:42 发布