8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for UTL_MAIL : Email from PL/SQL in the Oracle Database


Anonymous said...

I got below error please help

Error report -
ORA-06550: line 2, column 3:
PLS-00201: identifier 'UTL_MAIL.SEND' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

Tim... said...

Hi.

It looks like you didn't do the setup bit. First thing in the article.

Cheers

Tim...

Anonymous said...

We are try long to send mail from database but there is no proper example or document to resolve issue of error
ORA-29279: SMTP permanent error: 530 5.7.0 Must issue a STARTTLS command first
please do something which solve the issue

Tim... said...

Hi.

This method, and most of the alternatives, should only be used for a local mail relay on the database server. Not to connect to an external mail server.

I would suggest you set up a mail relay on the database server, and connect that mail relay to your external mail server.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.