DECLARE
  new_id_oferta NUMBER(6) := 0;
BEGIN

  BEGIN
    SELECT acd.id_ofert.NEXTVAL
      INTO new_id_oferta
      FROM acd.oferta
     WHERE ROWNUM = 1;
  END;

  INSERT INTO acd.oferta
    (id_oferta,
     cod_empr,
     cod_disc,
     ano_leti,
     sem_leti,
     cod_inst,
     nr_sala,
     periodo,
     par_pres,
     des_ofer,
     tot_vaga)
    SELECT new_id_oferta,
           :1,
           :2,
           t.ano_turm,
           t.sem_turm,
           t.cod_inst,
           t.nr_sala,
           t.periodo,
           '100',
           'Desc',
           t.num_vaga
      FROM acd.turmas t
     WHERE cod_inst = 1
       AND cod_turm = 102086;
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    new_id_oferta := 0;
END;