通过oracle数据库调用odi包或接口的任何方法

问题描述

我需要通过数据库参数过程来执行odi打包/映射，还需要捕获过程中的打包/映射状态(失败/通过).

I need to execute the odi package/mapping through database parametric procedure along with that i need to capture the package/Mapping status(Failed/Passed) in procedure .

ODI版本:12c

ODI Version : 12c

我尝试了上述代码，并显示了所附的错误消息:

i have tried the mentioned code and it's showing the attached error message:

推荐答案

您可以分两个步骤进行操作:

You can do it in two steps:

1. 创建一个将运行shell脚本/行命令的plsql过程
2. line命令将调用地图的ODI场景.

您可以通过阅读此书.

执行命令行的PL/SQL过程:

PL/SQL procedure that executes a command line:

create or replace procedure host( cmd in varchar2 )
as
status number;
begin
dbms_pipe.pack_message( cmd );
status := dbms_pipe.send_message( 'HOST_PIPE' );
if ( status <> 0 ) then raise_application_error( -20001, 'Pipe error' );
end if;
end;
/

第二点是在ODI文档中的 7.3.2从命令行执行场景.

Second point it's written in the ODI documentation, at chapter 7.3.2 Executing Scenario from command line.

这篇关于通过oracle数据库调用odi包或接口的任何方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！