Monday , May 20 2024

ORA-06502: PL/SQL: numeric or value error

When trying to send an e-mail with the UTL_MAIL package, the error “ORA-06502: PL / SQL: numeric or value error” is received when the smtp_out_server start parameter is not set even though there is no problem in its parameters or parameter values.

The error received will be as follows.

The smtp_out_server parameter should be set to solve the problem. It can be set as follows.

Then, the problem will be solved.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *