## PCD_MAJBILAVEMATPRO

Doc
Details
Grants
References
Dependencies
Code

TEXT
    PROCEDURE          "PCD_MAJBILAVEMATPRO"
    ( mat_id IN NUMBER
    , act_id IN NUMBER
    , bil_ave_id IN NUMBER
    , pbilan IN CLOB
    , pavenir IN CLOB
    ) AS
    BEGIN
      insert into bilans_avenirs_mat_pro values(mat_id,act_id,bil_ave_id,pbilan,pavenir);
      commit;
    EXCEPTION
      WHEN DUP_VAL_ON_INDEX THEN
      update bilans_avenirs_mat_pro set bilan = pbilan, avenir = pavenir where
      pf_matiere = mat_id and pf_groupe = act_id and bil_ave_id = pf_bilan_avenir;
      commit;
    END PCD_MAJBILAVEMATPRO;