Run ETL task from sql

set serveroutput on;

——————- kick out asyn task ————————————–
DECLARE
P_TASK_ID VARCHAR2(200);
P_DOMAIN VARCHAR2(200);
P_STATUS NUMBER;
P_XML_RESULT XMLTYPE;
p_response varchar(4000);
p_res clob ;
BEGIN

select ‘task_test-abcdefg’ into p_Task_id from dual;
select ‘ETLORI’ into p_domain from dual;
etl_task_mgr.run_etl_task(p_task_id
, (more…)

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Existing Users Log In
 Remember Me  
New User Registration
*Required field