Really need help...skill testing question

Hello experts,

I just wrote some code to email users using UTL_SMTP. Now my problem is in the body of the email I want to say "Here is your hyperlink" and then display the link. I have the link sitting in a database that I want to pull out and display however when the user receives the email one cannot click the link to goto the hyperlink it is just plain black text. Here is part of the code that does this

 message := 'Hello'||v_data.Name||',<BR> <BR>
Here is the hyperlink:<BR><BR>'||
v_data.Link;

Obviously there is more code to this but this is the jist of the code. Any ideas. The Link field in the database is a Varchar2(4000). It's an oracle database using oracle 10 with microsoft exchange server.

Thanks. Received on Thu Jul 20 2006 - 10:22:56 CDT