Executing SQLScript
I'm trying to schedule a job to execute the PLSQL code bellow then it shows that everything run ok, but it's not. have anyone experienced something like this?
Job Script:
declare
ret number:=0;
begin
if fun_confirma_exec_grupo('Grupo Indices Tecnicos',0) = 1 then
ret:=run_owb_map(p_repos_owner => 'OWBRUN'
,p_location_name => 'DW_PROX'
,p_task_type => 'PLSQL'
,p_task_name => 'PC_FILTRO_INDICE_TECNICO'
,p_system_params => ','
,p_custom_params => ','
,p_oem_friendly => 1);
dbms_output.put_line(ret);
else
dbms_output.put_line('O Grupo Indices Tecnicos não foi agendado na tabela TBMTD_PROCESSO_PARA_CARGA');