Enterprise Manager Generic (MOSC)

MOSC Banner

Executing SQLScript

edited Jan 12, 2010 2:50AM in Enterprise Manager Generic (MOSC) 5 commentsAnswered
Hi All,

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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center