Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Email with hyperlink text (mailto:)

MarcLafJan 4 2019 — edited Jan 4 2019

Hi,

I have an application that sends Email (using UTL_SMTP) based on certain condition. All my message text for the body of the email is stored in a table. Everything works fine as is...

But I want to know how to ADD an hyperlink that would send an email to a person (mailto:) to my text body (in the table) so that when the user receives the Email the hyperlink is active and working?

The following is my table structure and data:

pastedImage_0.png

How would I insert the hyperlink function for the circled text in the MSG_LINE in my table?

Thanks in advance,

Marc L
Comments
Post Details
Added on Jan 4 2019
1 comment
594 views