Home » Developer & Programmer » Forms » send email from oracle 10g forms
send email from oracle 10g forms [message #311047] Thu, 03 April 2008 05:19 Go to next message
alpeshirkal
Messages: 9
Registered: August 2006
Location: Bahrain
Junior Member
Hi users

I wanted to send email from oracle 10g forms so how can i send.
can any one provide me some sample code for this.

thanking you in advance.



alpesh
Re: send email from oracle 10g forms [message #311255 is a reply to message #311047] Thu, 03 April 2008 18:11 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Do not 'hijack' a thread that is for a different version of Forms.

Search this forum for 'mail' or 'email'. It is a common question and there are many fully worked threads.

David
Re: send email from oracle 10g forms [message #324255 is a reply to message #311255] Sun, 01 June 2008 02:20 Go to previous messageGo to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Dear All,

For sending email, I am facing different problem now. Before we had all the user's computer installed with forms runtime and MS OUTLOOK setup. So, sending mail from the forms I had no problem.

Recently, we installed Terminal Server (The advantage using this terminal server is I just need to install forms/reports runtime only to this system). All the user will access this system using "remote desktop connection"). All forms, reports working fine except email. Is there any other alternate to send email when the user connected with Terminal server?.

Expecting your valuble suggestion.

Ilango





Re: send email from oracle 10g forms [message #335371 is a reply to message #324255] Tue, 22 July 2008 00:38 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

Did you look at 'utl_mail' and 'utl_smtp'?

David
Re: send email from oracle 10g forms [message #390916 is a reply to message #335371] Tue, 10 March 2009 04:56 Go to previous messageGo to next message
Khan_4u
Messages: 5
Registered: February 2009
Location: UK
Junior Member
how we use utl_mail
Re: send email from oracle 10g forms [message #390936 is a reply to message #390916] Tue, 10 March 2009 06:43 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
UTL_MAIL
Re: send email from oracle 10g forms [message #424540 is a reply to message #390936] Sat, 03 October 2009 02:19 Go to previous messageGo to next message
itztamr
Messages: 9
Registered: August 2009
Location: Kuwait
Junior Member
Dear All,

Could anyone help me to send mail using utl_mail package.

I searched entire threads and even forms.. but i dont find much clear data or idea..

A code without any errors??

Thanks,
Tam.R ( Kuwait)
Re: send email from oracle 10g forms [message #424542 is a reply to message #424540] Sat, 03 October 2009 03:19 Go to previous messageGo to next message
itztamr
Messages: 9
Registered: August 2009
Location: Kuwait
Junior Member
When i try to install UTL_MAIL , I am getting this error,



SQL> @D:\oracle2\product\10.2.0\db_2\RDBMS\ADMIN\utlmail.sql

Package created.


Synonym created.

SQL> @D:\oracle2\product\10.2.0\db_2\RDBMS\ADMIN\prvtmail.plb

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY UTL_MAIL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
319/5 PL/SQL: SQL Statement ignored
320/10 PL/SQL: ORA-00942: table or view does not exist
325/7 PL/SQL: SQL Statement ignored
326/12 PL/SQL: ORA-00942: table or view does not exist



Can any one help me?


Thanks in advance,

Tam.R( Kuwait)
Re: send email from oracle 10g forms [message #426341 is a reply to message #424542] Thu, 15 October 2009 00:45 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Can you find 'utl_smtp'? If yes, then use it.

David
Previous Topic: call oracle 9i report from oracle report9i using hyperlink
Next Topic: Connecting FORMS6i to SQLSERVER
Goto Forum:
  


Current Time: Fri Sep 20 06:30:26 CDT 2024