Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Really need help...skill testing question
clinttoris_at_hotmail.com wrote:
> Brian Peasland wrote:
>> clinttoris_at_hotmail.com wrote: >>> 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. >>> >> From above, I can see that you know that you have to include HTML >> markup tags such as "<BR>". But you'll also have to include the "<A >> HREF>" tag around your link as well. >> >> This works if your recipient receives email as HTML code, but what if >> their email program receives mail as straight text? >> >> Cheers, >> Brian >> >> >> >> -- >> =================================================================== >> >> Brian Peasland >> dba_at_nospam.peasland.net >> http://www.peasland.net >> >> Remove the "nospam." from the email address to email me. >> >> >> "I can give it to you cheap, quick, and good. >> Now pick two out of the three" - Unknown
Your HREF tag is incomplete. You have the link name wrapped in between the <a> and </a> tags. This is what the user sees. However, you have not provided the information for the browser to actually make it a link. Try something more like this:
message := 'Hello'||v_data.Name||',<BR>
<BR>
Here is the hyperlink:<BR><BR>'||
'<a href='||v_data.link||'>'||v_data.link||'</a>';
> Also, not sure what you mean with your last part about what if they
> receive email as straight text. How do I know this? Does Microsoft
> outlook have a setting for this? Could you expand on this. Thanks
> again brian.
Outlook, Outlook Express, and many of the other email programs in use today can display both HTML and Text emails. Now that I think about it, I cannot think of email programs in wide use today that cannot do both (that wasn't the case a number of years ago). So my original comment is probably nothing to worry about.
Cheers,
Brian
-- =================================================================== Brian Peasland dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu Jul 20 2006 - 11:25:49 CDT