CREATE OR REPLACE PROCEDURE MAIL.PDB1_INVIO_MAIL_CLOB(P_FROM      IN VARCHAR2,
                                                      P_TO        IN VARCHAR2,
                                                      P_CC        IN VARCHAR2 DEFAULT NULL,
                                                      P_OBJECT    IN VARCHAR2,
                                                      P_TEXT      IN clob,
                                                      P_ATTACH    IN VARCHAR2 DEFAULT NULL,
                                                      P_MAIL_TYPE IN VARCHAR2 DEFAULT 'TEXT') IS
  v_mail_server varchar2(250);
BEGIN
  begin
    select meaning
      into v_mail_server
      from pra_lookups
     where lookup_type = 'PII_MAIL_SERVER'
       and lookup_code = 'PII_CLOUD_INSTANCE'
       and sysdate between start_date_active and
           nvl(end_date_active, sysdate + 1);
  exception
    when others then
      v_mail_server := 'smtpmail.np.ge.com';
  end;

  if p_to is null then
    raise_application_error('Destinatario assente!', -20000);
  end if;
  --  dbms_mail_service_ext_att.init('msxitfi01npge.np.ge.com','msxitfi01npge.np.ge.com',P_FROM);
  --  dbms_mail_service_ext_att_clob.init('smtpmail.np.ge.com','smtpmail.np.ge.com',P_FROM,P_MAIL_TYPE);
  dbms_mail_service_ext_att_clob.init(v_mail_server,
                                      v_mail_server,
                                      P_FROM,
                                      P_MAIL_TYPE);
  dbms_mail_service_ext_att_clob.SendPlainTextMessageClob(P_TO,
                                                          nvl(P_CC, ' '),
                                                          P_OBJECT,
                                                          P_TEXT,
                                                          nvl(p_ATTACH, ' '));
END PDB1_INVIO_MAIL_CLOB;