Todas oi,

Agora estou correndo o 3 oráculo procedimentos manualmente um por um.

Consulta: 1. Processo OUT_PUT Se for Success, então chamada 2. Processo.
Caso 2. Processo OUT_PUT é sucesso, então chamada 3. Processo.

1. Processo Se não for, então não há necessidade de chamar os outros
procedimentos.

Como Agendar 1 ª, 2 ª, 3. Procedimentos empregos são @
###############################################
CALENDÁRIO DE EMPREGOS
###############################################
# 30 01 * * * / u14/ods/scripts/in_pps_state_change.sh>> / u14/ods/scripts/scriptslog/in_other_mail.log 2> & 1

# 00 03 * * * / u14/ods/scripts/in_pps_cos_change.sh>> / u14/ods/scripts/scriptslog/in_other_mail.log 2> & 1

# 30 04 * * * / u14/ods/scripts/in_pps_usage_change.sh>> / u14/ods/scripts/scriptslog/in_other_mail.log 2> & 1


################################################
ABERTURA DO PROCESSO ORACLE shell script
################################################
Por exemplo, chamada de SP:: in_pps_usage_change.sh

Retval \u003d `sqlplus-s ODS / ODS ODSDB @ <<EOF
SET SERVEROUTPUT no tamanho 100.000
Declare
OUT_STATUS NÚMERO;
OUT_MSG VARCHAR2 (200);
Começo
ODS_SP_REMOVE_PRE_SUB_DUP (OUT_STATUS, OUT_MSG);
dbms_output.put_line ( 'KeepThis' | | OUT_STATUS | |' '| | nvl (OUT_MSG ,''));
End;
/
SET OFF SERVEROUTPUT
EXIT;
EOF `

X \u003d `echo $ Retval | grep KeepThis | awk '(print $ 2)'`
Y \u003d `echo $ Retval | grep KeepThis | awk '(print $ 3)'`

echo "">> $ USER_LOG
echo "Processo: ODS_SP_REMOVE_PRE_SUB_DUP saída é:">> $ USER_LOG
echo "OUT_STATUS \u003d $ X">> $ USER_LOG
echo "OUT_MSG \u003d $ Y">> $ USER_LOG

################################################


Por favor, me fornecer a solução da minha dúvida ..

Thanks & Regards
Hanuma