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:
> clinttoris_at_hotmail.com wrote:
> > Brian Peasland wrote:
> > > 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
> > > >
> > > >
> > > > 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.
> > >
> > > 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" - Unknown
> >
> >
> > Brian,
> >
> > Thanks so much. That did the trick. I corrected the a href syntax and
> > it is working fine now. Have a great day Brian.
>
sorry everyone,
It is working with utl_smtp.rcpt(mail_conn, 'xxx_at_xxx.com); but it is not working if I try and send external emails. It only works with internal emails. Received on Thu Jul 20 2006 - 14:00:11 CDT