Really need help...skill testing question

FAQ

Memberlist

Usergroups

Profile

Preferences

· nixdoc.net

· man pages

· Linux HOWTOs

· FreeBSD Tips

· Forums

Forum index » Databases » Oracle

Really need help...skill testing question

Page 1 of 1 [8 Posts]

View previous topic :: View next topic

Author

Message

clinttoris@hotmail.com
*nix forums beginner

Joined: 26 Jun 2006
Posts: 8

Posted: Thu Jul 20, 2006 3:22 pm Post subject: Note

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||', 
 
Here is the hyperlink: '||
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.

Brian Peasland
*nix forums Guru

Joined: 04 Apr 2006
Posts: 301

Posted: Thu Jul 20, 2006 3:45 pm Post subject: Note

Re: Really need help...skill testing question

clinttoris@hotmail.com wrote:

Quote:

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||', '||
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 " ". 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@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

clinttoris@hotmail.com
*nix forums beginner

Joined: 26 Jun 2006
Posts: 8

Posted: Thu Jul 20, 2006 4:05 pm Post subject: Note

Re: Really need help...skill testing question

Brian Peasland wrote:

Quote:

clinttoris@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||', '||
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 " ". 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@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||', 
 
Here is the hyperlink: '||
'<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.

Brian Peasland
*nix forums Guru

Joined: 04 Apr 2006
Posts: 301

Posted: Thu Jul 20, 2006 4:25 pm Post subject: Note

Re: Really need help...skill testing question

clinttoris@hotmail.com wrote:

Quote:

Brian Peasland wrote:
clinttoris@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||', '||
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 " ". 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@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||', '||
'<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||', 
 
Here is the hyperlink: '||
'<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.

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@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

clinttoris@hotmail.com
*nix forums beginner

Joined: 26 Jun 2006
Posts: 8

Posted: Thu Jul 20, 2006 4:43 pm Post subject: Note

Re: Really need help...skill testing question

Brian Peasland wrote:

Quote:

clinttoris@hotmail.com wrote:
Brian Peasland wrote:
clinttoris@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||', '||
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 " ". 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@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||', '||
'<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||', '||
'<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@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.

clinttoris@hotmail.com
*nix forums beginner

Joined: 26 Jun 2006
Posts: 8

Posted: Thu Jul 20, 2006 6:48 pm Post subject: Note

Re: Really need help...skill testing question

clinttoris@hotmail.com wrote:

Quote:

Brian Peasland wrote:
clinttoris@hotmail.com wrote:
Brian Peasland wrote:
clinttoris@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||', '||
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 " ". 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@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||', '||
'<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||', '||
'<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@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.

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 only
send 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@xxx.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

clinttoris@hotmail.com
*nix forums beginner

Joined: 26 Jun 2006
Posts: 8

Posted: Thu Jul 20, 2006 7:00 pm Post subject: Note

Re: Really need help...skill testing question

clinttoris@hotmail.com wrote:

Quote:

clinttoris@hotmail.com wrote:
Brian Peasland wrote:
clinttoris@hotmail.com wrote:
Brian Peasland wrote:
clinttoris@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||', '||
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 " ". 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@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||', '||
'<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||', '||
'<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@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.

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 only
send 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@xxx.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

sorry everyone,

It is working with utl_smtp.rcpt(mail_conn, 'xxx@xxx.com); but it is
not working if I try and send external emails. It only works with
internal emails.

Brian Peasland
*nix forums Guru

Joined: 04 Apr 2006
Posts: 301

Posted: Thu Jul 20, 2006 8:30 pm Post subject: Note

Re: Really need help...skill testing question

Quote:

It is working with utl_smtp.rcpt(mail_conn, 'xxx@xxx.com); but it is
not working if I try and send external emails. It only works with
internal emails.

This should probably be a new thread as it is an entirely new
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@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

Google

Display posts from previous:

Page 1 of 1 [8 Posts]

View previous topic :: View next topic

The time now is Mon Dec 01, 2008 7:28 pm | All times are GMT

Forum index » Databases » Oracle

Jump to:

Topic		Author	Forum	Replies	Last Post
Similar Topics
	Newbie question: How to forward a domain to a mailbox?	leei	Postfix	0	Fri Aug 24, 2007 4:55 pm
	configuration question for httpd	Karl Wang	Apache	1	Fri Jul 21, 2006 2:10 pm
	nim problem/question	Ron	AIX	0	Fri Jul 21, 2006 1:57 pm
	question for JAVA developer who r using postgres sql as b...	deepak pal	PostgreSQL	1	Fri Jul 21, 2006 9:00 am
	Testing my Black List	Marc Perkel	Exim	6	Fri Jul 21, 2006 5:57 am

Mortgages | Mortgages | Debt | Debt Help | Internet Advertising

Other DeniX Solutions sites: Unix/Linux blog | electronics forum | medicine forum | science forum |

[ Time: 0.4712s ][ Queries: 16 (0.3371s) ][ GZIP on - Debug on ]