Forms :: How To Send Automated Email From Oracle Form

May 10, 2011

I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,

View 1 Replies


ADVERTISEMENT

Forms :: How To Send Email From Oracle 10g

Sep 27, 2011

I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.

View 16 Replies View Related

Forms :: Email Send From Oracle 6i?

Jun 25, 2012

tell the setting and code how send email through oracle?

View 4 Replies View Related

Forms :: Send Email Through 6i?

Nov 11, 2011

i want to send email and message on mobile phone through forms 6i.

View 1 Replies View Related

SQL & PL/SQL :: Send Email In Oracle?

Apr 24, 2013

what is the best way to send an email in oracle?

1.utl_smtp
2.utl_mail
3.utl_tcp

View 6 Replies View Related

Forms :: 10g - Send Email From Application?

May 28, 2013

I want to send an email from my Application forms 10g .But I receive

DECLARE
l_mailhost VARCHAR2(64) :=... //admin mail
l_from VARCHAR2(64) := ... //admin mail
l_to VARCHAR2(64) := ...//user mail
l_mail_conn sys.UTL_SMTP.connection;

[Code] ........

message displayed is: no internet connection !!

View 3 Replies View Related

SQL & PL/SQL :: Send HTML Email From Oracle?

Dec 21, 2009

Am trying to send email from Oracle using utl_smtp.

My issue is regarding Arabic character. I set the charset to windows-1256 and even tried with other different charset like UTF-8.

I used also: utl_smtp.write_raw_data(l_connection,utl_raw.cast_to_raw(dbms_lob.substr(data).

Before i set all these changes to the procedure i was receiving the Arabic text as '??????'

However, after above modifications, the text display changed to something like this : ÇäÇÓààååÑêå

Does the problem still in the DB side or it can be coming from mail server ?

View 24 Replies View Related

SQL & PL/SQL :: Unable To Send Email From Oracle XE?

Jun 23, 2010

I have ORacle XE installed on my machine and everything works fine. I can connect to it using forms, run my application etc. Now, I wanted to write a proc which can send email from Oracle XE.So after investigating, I think UTL_SMTP and UTL_MAIL are my options. For which I need to enable the ut_mail package and one more which I have done. But everytime I run a package, I get the error

DECLARE
v_From VARCHAR2(80) := 'oracle@mycompany.com';
v_Recipient VARCHAR2(80) := 'test@mycompany.com';
v_Subject VARCHAR2(80) := 'test subject';
v_Mail_Host VARCHAR2(30) := 'mail.mycompany.com';
v_Mail_Conn utl_smtp.Connection;
crlf VARCHAR2(2) := chr(13)||chr(10);

[code].....

Ora 29278 SMTP transient error.

View 13 Replies View Related

Forms :: How To Send Pic And TEXT In Email Using PLSQL

Jun 13, 2010

I am create procedure send the message in form bulider10g to Internet email and the procedure is work .

but now I want to modify this procedure , I want to add picture of my country ( logo ) and the original message . why cant display the image in my email ?

this code of image

<p align="center"><img border="0" src="logo.gif" width="20" height="20"></p>

I Think the problem of this code because 'Content-type: text/html' not image ?????!!!!!!!

utl_smtp.data(v_Mail_Conn, 'MIME-Version: 1.0' ||CHR(13)|| CHR(10)||'Content-type: text/html' || CHR(13)||CHR(10)||mesg);

procedure

EMAIL_SEN VARCHAR2(250);
EMAIL_REC VARCHAR2(250);
DESC_EN VARCHAR2(250);
UB_SEQ NUMBER(10);
BEGIN
DECLARE
v_From VARCHAR2(80) :=admin@yahoo.com ;
[code].........

View 2 Replies View Related

Application Express :: Can't Send Email Using 3.0.1.00.07 Oracle 10g

Jul 17, 2012

Can't send an email using Application Express 3.0.1.00.07 on oracle 10g.

my code is:
DECLARE
l_body CLOB;
v_email varchar(30);
BEGIN

SELECT CONTACT_EMAIL
INTO v_email
FROM persal_info
WHERE TRIM(PERSAL)= TRIM(:P48_PERSAL);
l_body := 'Your access code for the Transport system is:'|| :P48_CODE ;
l_body := l_body || '

This access code is needed in order for you to complete the claim form. It is important to change this access code for the confidentiality of your information.';

apex_mail.send( p_to => v_email,
p_from => 'PietC@google.com',
p_body => l_body,
p_subj =>'Access Code'
);

View 1 Replies View Related

Forms :: How To Send Reports From D2k Form To Mail

Jul 21, 2011

How to send reports from d2k form to mail.

View 1 Replies View Related

Forms :: Making Form Of Email Sender

Mar 30, 2011

I want to make form of email sender.

View 2 Replies View Related

SQL & PL/SQL :: How To Send Email With Attachment

May 4, 2010

I need to send email with attachment file. The input file is reside in the server. Currently, i can create and send file through the email. But it is not the file that i want from the server, it is actually create the attachment file. How can i get the file from server and put it as attachment? below is the codes :

create or replace
Procedure test_email_mt(p_sender IN VARCHAR2,
p_recipient IN VARCHAR2,
p_message IN VARCHAR2)
as

[code]...

View 5 Replies View Related

SQL & PL/SQL :: Send Email From Procedure

Dec 9, 2010

Need info regarding sending an excel file attachment from plsql.I am using utl_smtp package in procedure and want to attach some sql query results in excel file.Is it possible to use sql query in same stored procedure that i am using to send the email attachment or i need to use external directory path to load the file as attachment.

View 9 Replies View Related

PL/SQL :: Attached XML File And Send Email

Jan 18, 2013

I have ready xml file of around 100KB at location C: est.xml .

Now I just want to attached this file and send email to particular person using Oracle PL/SQ . can I get code for that?

View 1 Replies View Related

SQL & PL/SQL :: Send Email Using UTL_SMTP With UTF-8 Coding

Dec 30, 2011

I'm trying to send e-mail using UTL_SMTP with UTF-8 coding. I have a problem that the UTF-8 letters become `?`.

So here is the

p_to varchar2(250);
p_from varchar2(250):='email_address';
p_subject varchar2(250):='...vienotā...';
P_smtp_hostname varchar2(255) := 'IP';
P_smtp_portnum varchar2(5) := '25';
[code].......

The code is taken an example from internet source. Everything works fine but the UTF-8 not .

View 21 Replies View Related

Send Email With Attachment Using Stored Procedure?

Jun 17, 2011

I would like to send an email with attachment using a STORE PROCEDURE, with a PL/SQL, I was testing a package called SRW.RUN_REPORT but the problem is that the report generate a pdf file but this file is storage in application server because the report server run over the application, wo we can not get the physical file to send as attach.

the problem is generate the pdf file save in a place that we can get easier.

View 8 Replies View Related

Reports & Discoverer :: Send Report PDF Through Email

Jun 4, 2012

i have installed oracle application server forms and report services, and i am deploying my forms and reports on it and its working fine, now i have a new requirement to send email through reports. I am already generating reports on pdf form and displaying on screen. How can i send this report PDF as an attachment and send it to different email addresses or how can i setup oracle application report services to send emails as an attachment.

View 3 Replies View Related

SQL & PL/SQL :: Unable To Send Email Through Google To Private Domain

Dec 1, 2012

how to send email (PL/sql Procedure) to private domain through google mail.

View 2 Replies View Related

User-defined Metric Doesn't Send Email

Dec 18, 2010

I'm attempting configure User-defined Metric to send mails when happen warning or critical alerts .My environment is Cluster Database and I'm using OEM Grid Control

I created User-defined Metric for monitoring invalid object for example and scheduled this collect to every 5 minutes.On initial OEM page, I see alert violation, but don't receive mail for this. In my Notification Rules page, I added "User-Defined Numeric Metric" and includes object Check_Invalid_Objects, wich is my UDM.I receive several alerts violations, but don't UDM.

 UDM_Violation.png ( 116.68K )
Number of downloads: 0

 NotificationRule.jpg ( 218.78K )
Number of downloads: 0

 ScheduleNotification.jpg ( 373.64K )
Number of downloads: 0

View 6 Replies View Related

Workflow :: To Send Notifications To Multiple Supplier Email IDs?

Aug 26, 2013

I have a custom concurrent program which has a SQL query which returns multiple rows. Each row is a for each supplier e.g. 

Supplier1      sup1@gmail.com     123     5000Supplier2      sup2@gmail.com      456    4000Supplier3      sup3@gmail.com      789    3000 

This set is returned based upon some criteria mentioned in the where clause of the SQL.Ultimate aim is to send 1 notification to each of the email id's and those notification should have the corresponding attribute values. 3 notifications fired from a workflow triggered by the concurrent program (which actually returns this 3 rows in a SQL)Supplier 1 to receive  5000Supplier2 to receive  4000Supplier3 to receive  3000 My approach / or the only approach coming in mind is using a cursor for the SQL inside the concurrent program and using a for loop, initiating the workflow each time for a loop iteration i.e for each iteration of loop , workflow procedure will need to be initiated, so item type will be same but item key will of 3 different item key.  is it somehow possible to fire only one instance of workflow and not 3 different instances to send 3 notifications. Ad hoc role creation would not be option here because the number of rows may be large and not just 10-15.

View 0 Replies View Related

Reports & Discoverer :: How To Generate Report And Send Straight To Email

Apr 11, 2013

How to generate a report and straight send it to an Email? I want to match student reg number and the parents email provided .

View 1 Replies View Related

Server Utilities :: Send Email After Export Done (successfully Without And With Error )

Jun 16, 2011

I have a ORACLE 10g(10.2.0.1.0) database that I am running on windows. I have export backups batch file running every day through windows scheduler. I would like to know If there is some way that sends me an email after the backup is finished and also send me if it does not finish with error.

I have successfully done this om my SQL Server machine but don't know for ORACLE as I have not purchased it and have license

View 16 Replies View Related

SQL & PL/SQL :: Send Email Attachment Using Utl_mail.send_raw Utility And Not Successful

Jun 6, 2011

I am trying to send an email attachment using "utl_mail.send_raw" utility and not successful. Constantly I keep getting an error:

"ORA-20001: An error has occured: ORA-20001: ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "APPOWNER.SANDEEP_CT_FILE", line 103"

I think it's emanating from "ORA-06508: PL/SQL: could not find program unit being called".

a) this morning my production dba " utlmail.sql in DEVELOPMENT as sys.

b) Create or replace directory TEMP_SANDEEP as '/u01/data' (This was created so that BFILENAME could read it + "dbms_lob.fileopen" needs to access this from Oracle directory and not Operating system directory)

c) 'u01/data' exists on Unix development box.

d) Then I created the following procedure to create a text file (text file's name is currentdate.txt i.e. 06062011.txt) that has some information. Once created, the UTL_MAIL.SEND_RAW should pick this file up and email this to concerned parties(and in this case it's me as I am doing this on development environment).

Code for the above is as follows:

CREATE OR REPLACE procedure sandeep_ct_file is
/*Variable declarations */
v_dir_location varchar2(100);
v_file_name varchar2(100);
v_file_handle UTL_FILE.FILE_TYPE;
v_report LONG := chr(10)||'Prog Code' ||' '||
[code]....

Do I have to defined SMTP connections and parameters?

View 10 Replies View Related

SQL & PL/SQL :: How To Send Email In HTML Format By Executing Anonymous Procedure

Oct 11, 2010

How to send email in HTML format as an attachment/email body by executing oracle anonymous procedure

View 1 Replies View Related

Application Express :: Add Button On Report Region Named As Send Email

Dec 28, 2012

I want to add button on report region Named as "Send E-mail" that should be on each row

so how can i do?

View 8 Replies View Related

Forms :: How To Send Mail To Lotus Notes With Attachment From Oracle Forms

Feb 7, 2011

Query :"how to send mail to lotus notes with attachment from oracle forms"?

View 2 Replies View Related

Forms :: Send SMS Using Oracle 6i

Feb 4, 2013

I have successfully implemented the from which I can send SMS using Forms 6i and any mobile modem connected with OS.Now you can send SMS using Oracle Forms 6i.

View 15 Replies View Related

Forms :: Oracle 6i Send SMS Through GSM Modem?

Jun 29, 2012

i want to send sms through gsm modem in oracle form 6i.

View 3 Replies View Related

Forms :: How To Send Sms To Mobile Device Using Oracle 6i

Oct 19, 2013

I want to send sms to the mobile using Oracle form 6i.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved