Hi Everyone,
I have a function send_mail working since several years and recently it stopped working generating following error :
ORA-29278: erreur non persistante SMTP : 421 Service not available
ORA-29279: erreur permanente SMTP : 550 5.7.1 https://support.google.com/a/answer/6140680#invalidcred ffacd0b85a97d-3a561a35b88sm70518f8f.48 - gsmtp
It seems it is due to SMTP server : smtp-relay.gmail.com that knows requires Authentification and TLS
I tried to create a wallet containing roots.pem I got from https://support.google.com/a/answer/6180220?hl=en
I amended my function to replace :
UTL_SMTP.open_connection(
host => Srv_Smtp,
port => Port
);
With
UTL_SMTP.open_connection(
host => Srv_Smtp,
port => Port,
wallet_path => 'file:D:\Wallet\wallet\',
wallet_password => ‘WalletPasswd123’
);
I added call to UTL_SMTP.STARTTLS and UTL_SMTP.AUTH
And I changed the port from 25 to 587
And now I get following error at UTL_SMTP.STARTTLS stage:
ORA-29024: Echec de validation de certificat
And this one at UTL_SMTP.AUTH stage :
ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: erreur de conversion des caractères en chiffres
And finally still get error :
ORA-29278: erreur non persistante SMTP : 421 Service not available
Does anyone would be able to help us please?
Thanks
Best regards,