send email from oracle 10g forms [message #311047] |
Thu, 03 April 2008 05:19 |
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 #324255 is a reply to message #311255] |
Sun, 01 June 2008 02:20 |
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 #424540 is a reply to message #390936] |
Sat, 03 October 2009 02:19 |
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 |
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)
|
|
|
|