Hi all,
the developer team goes back to us a problem with a procedure.
This procedure return sometimes an ORA-08103 error message.
Do you have an idea?
Thanks.
PROCEDURE Preparer_Alimentation is
p_error varchar2(1000);
BEGIN
execute immediate 'truncate table ECA_ADOBE_CAMPAIGN_CONTRAT';
execute immediate 'truncate table ECA_ADOBE_CAMPAIGN_STATUT';
INSERT_STATUT(p_id => 1,
p_code => 'PREP1',
p_nom_procedure => 'Preparer_Alimentation');
insert into ECA_ADOBE_CAMPAIGN_CONTRAT
(ID_CONTRAT,
ID_OFFRE_ENGAGEMENT,
DATE_ENTREE,
SOLDE_POINTS,
MONTANT_OCC_AMBASSADEUR,
MONTANT_OCC_4P,
SCORE,
date_fin_engagement)
SELECT ct.id_contrat,
ct.id_offre_eng,
ct.date_entree,
cl.solde_points,
ct.montant_occ_ambassadeur,
ct.montant_occ_4p,
sc.score_churn_dfpc,
ct.date_fin_engagement
FROM synthese.syn_contrat ct,
synthese.syn_scorecontrat sc,
synthese.syn_client cl
WHERE ct.numcontrat = sc.numcontrat(+)
and ct.idclient = cl.idclient
AND (ct.statut = eca_constantes.CST_CONTRAT_ACTIVE OR
ct.statut = eca_constantes.CST_CONTRAT_SUSPENDU)
--and eca_push_offres.CHANGEMENT_TARIF_EN_COURS(p_id_contrat => ct.id_contrat) = eca_constantes.CST_0 -- pas de changement de tarif en cours
and EST_OFFRE_ENG_PP(p_id_offre_eng => ct.id_offre_eng) = eca_constantes.CST_0;
commit;
UPDATE_STATUT(1, 1);
EXCEPTION
WHEN OTHERS THEN
p_error := SQLCODE || ' - ' || SQLERRM;
Enregistrer_Erreur('Preparer_Alimentation', p_error);
UPDATE_STATUT(1, 0);
END Preparer_Alimentation;