 | |
Really need help...skill testing question
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Really need help...skill testing question -
07-20-2006
, 10:22 AM
#2
| |||
| |||
|
|
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. |
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 (DOT) 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
#3
| |||
| |||
|
|
clinttoris (AT) hotmail (DOT) 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 (DOT) 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.
#4
| |||
| |||
|
|
Brian Peasland wrote: clinttoris (AT) hotmail (DOT) 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 (DOT) 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. |
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>';
Quote:
|
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. |
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 (DOT) 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
#5
| |||
| |||
|
|
clinttoris (AT) hotmail (DOT) com wrote: Brian Peasland wrote: clinttoris (AT) hotmail (DOT) 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 (DOT) 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 (DOT) 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.
#6
| |||
| |||
|
|
Brian Peasland wrote: clinttoris (AT) hotmail (DOT) com wrote: Brian Peasland wrote: clinttoris (AT) hotmail (DOT) 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 (DOT) 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 (DOT) 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. |
If I should start another thread please let me know and I do apologize.
Now that I have everything working
I was asked if I could not onlysend and email but also CC another address. I have a database table in
oracle that my send mail items(subject, email address, body) is being
populated. I am using a cursor to attain all the values in the
database and fire out an email to the recipient. I now need a cc
(which I want to use a field from the table as the address that will be
cc too) Any ideas how to do this. I have read that I can use
utl_smtp.rcpt(mail_conn, 'xxx (AT) xxx (DOT) com); with xxx being the address. I
tried this first by hard coding and it is only sending out to 1
address. Any ideas? Thanks again. Brian
#7
| |||
| |||
|
|
clinttoris (AT) hotmail (DOT) com wrote: Brian Peasland wrote: clinttoris (AT) hotmail (DOT) com wrote: Brian Peasland wrote: clinttoris (AT) hotmail (DOT) 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 (DOT) 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 (DOT) 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. Hello Brian or whomever can help. I wish to reopen this if possible. If I should start another thread please let me know and I do apologize. Now that I have everything working I was asked if I could not onlysend and email but also CC another address. I have a database table in oracle that my send mail items(subject, email address, body) is being populated. I am using a cursor to attain all the values in the database and fire out an email to the recipient. I now need a cc (which I want to use a field from the table as the address that will be cc too) Any ideas how to do this. I have read that I can use utl_smtp.rcpt(mail_conn, 'xxx (AT) xxx (DOT) com); with xxx being the address. I tried this first by hard coding and it is only sending out to 1 address. Any ideas? Thanks again. Brian |
It is working with utl_smtp.rcpt(mail_conn, 'xxx (AT) xxx (DOT) com); but it is
not working if I try and send external emails. It only works with
internal emails.
#8
| |||
| |||
|
|
It is working with utl_smtp.rcpt(mail_conn, 'xxx (AT) xxx (DOT) com); but it is not working if I try and send external emails. It only works with internal emails. |
topic...not that threads don't get off on a tangent once in a while....
UTL_SMTP needs a SMTP gateway. If you can send an email internally, then
your procedure is working fine from Oracle's perspective. If you cannot
send email externally, then this is most likely due to some limitation
of your SMTP gateway. Talk to your admins about this issue. You might
have to use a different SMTP gateway. Or they might have to get your
gateway set up to let you send external emails.
HTH,
Brian
--
================================================== =================
Brian Peasland
dba (AT) nospam (DOT) 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
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.