Home » SQL & PL/SQL » SQL & PL/SQL » FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES
FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES [message #608135] Sun, 16 February 2014 23:46 Go to next message
jgjeetu
Messages: 243
Registered: July 2013
Location: India Delhi Rohini Sec-1
Senior Member

PLEASE TELL FROM WHERE TO DOWNLOAD UTL_TCP, UTL_SMTP , UTL_MAIL PACKAGES.
IF POSSIBLE THEN KINDLY PROVIDE DOWNLOAD LINK .
THANKS
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 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
they are all included in current releases
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 Go to previous messageGo to next message
jgjeetu
Messages: 243
Registered: July 2013
Location: India Delhi Rohini Sec-1
Senior Member

i am using oracle 10g , are these present there already and if yes then where
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 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
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
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 Go to previous messageGo to next message
jgjeetu
Messages: 243
Registered: July 2013
Location: India Delhi Rohini Sec-1
Senior Member

then can you please tell me how to send email using oracle 10g
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 Go to previous messageGo to next message
jgjeetu
Messages: 243
Registered: July 2013
Location: India Delhi Rohini Sec-1
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
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 Go to previous messageGo to next message
Littlefoot
Messages: 19890
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');
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 Go to previous messageGo to next message
jgjeetu
Messages: 243
Registered: July 2013
Location: India Delhi Rohini Sec-1
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 .
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 Go to previous messageGo to next message
Littlefoot
Messages: 19890
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?
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 Go to previous messageGo to next message
jgjeetu
Messages: 243
Registered: July 2013
Location: India Delhi Rohini Sec-1
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:-
./fa/11704/0/
  • Attachment: Untitled.jpg
    (Size: 9.63KB, Downloaded 105 times)
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 Go to previous message
Littlefoot
Messages: 19890
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.
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:
  


Current Time: Sat Dec 20 21:29:36 CST 2014

Total time taken to generate the page: 0.08503 seconds