Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Really need help...skill testing question

Re: Really need help...skill testing question

From: <clinttoris_at_hotmail.com>
Date: 20 Jul 2006 09:05:20 -0700
Message-ID: <1153411520.770945.273860@p79g2000cwp.googlegroups.com>


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

Brian thanks for the reply.

As soon as I sent the message I did think of the a href and have added the code as follows

  message := 'Hello'||v_data.Name||',<BR>  <BR>
 Here is the hyperlink:<BR><BR>'||
'<a href=>'||v_data.link||'</a>';

So now it looks like I have a hyperlink when the user receives the email but when the user clicks the link they receive it is still unclickable. Any ideas.

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. Received on Thu Jul 20 2006 - 11:05:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US