Category Archives: PL/SQL

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…)