OraFAQ Forum: SQL & PL/SQL » FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL

Home » SQL & PL/SQL » SQL & PL/SQL » FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608135]

Sun, 16 February 2014 23:46

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

PLEASE TELL FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES.
IF POSSIBLE THEN KINDLY PROVIDE DOWNLOAD LINK .
THANKS

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608136 is a reply to message #608135]

Sun, 16 February 2014 23:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

they are all included in current releases

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608137 is a reply to message #608136]

Sun, 16 February 2014 23:54

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

i am using oracle 10g , are these present there already and if yes then where

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608138 is a reply to message #608137]

Sun, 16 February 2014 23:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

jgjeetu wrote on Sun, 16 February 2014 21:54

i am using oracle 10g , are these present there already and if yes then where

10g is obsoleted & unsupported

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608140 is a reply to message #608138]

Mon, 17 February 2014 00:06

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

then can you please tell me how to send email using oracle 10g

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608141 is a reply to message #608138]

Mon, 17 February 2014 00:10

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

no "Oracle introduced an improved package for sending E-mail in Oracle 10g - called UTL_MAIL- that should be used instead of UTL_SMTP. "
check this link:- http://www.orafaq.com/wiki/Send_mail_from_PL/SQL

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608152 is a reply to message #608141]

Mon, 17 February 2014 01:04

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does the following query return when you run it in your database?

SELECT owner, object_name, object_type
FROM all_objects
WHERE object_name in ('UTL_TCP', 'UTL_SMTP', 'UTL_MAIL');

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608153 is a reply to message #608152]

Mon, 17 February 2014 01:10

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

I don't know , i don't have much idea about these packages , i am trying to make an app
to send email using oracle forms, then i googled "how to send email using oracle 10g"
in response i came to know that we need these packages to send an email
that's why i asked for download link .

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608155 is a reply to message #608153]

Mon, 17 February 2014 01:17

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Well, thank you for taking your time and explaining all that, but - I asked you a quite simple question which requires you to copy my query and paste it into your SQL*Plus, execute it and let us know what it returned.

However, you said that you don't know what it returns.

If you don't know, is there anyone there (close to you) who could run that query? Your brother, grandmother, friend, anyone? Could you ask him/her to do that for you?

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608160 is a reply to message #608155]

Mon, 17 February 2014 01:25

jgjeetu
Messages: 373
Registered: July 2013
Location: www.Orafaq.com/Forum

Senior Member

i did that , but whats the benefit of that if i dont know much about that,
right now i dont have access to oracle 10g that's why i am using apex.oracle.com
by the way it returns:-
/forum/fa/11704/0/

Attachment: Untitled.jpg
(Size: 9.63KB, Downloaded 1355 times)

Report message to a moderator

Re: FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608161 is a reply to message #608160]

Mon, 17 February 2014 01:28

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That output is useless as it describes contents of a database that is used to run apex.oracle.com site.

Reply when you get access to your own database.

Report message to a moderator

Previous Topic:	What are valid and invalid functions in PL-SQL
Next Topic:	SQL gets not result in Ora Enterprise 11.1.0.7.0 but in 10 and 11 XE it does

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:22:11 CDT 2024