SQL & PL/SQL :: How To Do Attachment Email In Oracle

Jul 24, 2013

Below are my procedure and declaration. I can send email to internal and external with attachment.

But the attachment is blank. i don't know how to add path in the script. like i save 1 pic in d drive. from thr how i must do attachment.

below are the procedure

CREATE OR REPLACE PROCEDURE CUSTOMER.send_mail_2 (p_to IN VARCHAR2,
p_from IN VARCHAR2,
p_subject IN VARCHAR2,
p_text_msg IN VARCHAR2 DEFAULT NULL,
p_attach_name IN VARCHAR2 DEFAULT NULL,
p_attach_mime IN VARCHAR2 DEFAULT NULL,
[code].........

View 2 Replies


ADVERTISEMENT

SQL & PL/SQL :: Email Excel File As Attachment In Mail Through Oracle Procedure?

Mar 3, 2011

I need to email an excel file as an attachment in the mail through oracle procedure. I am using UTL_TCP option.

The remote_host i use in test environment is the 'name of the test server'. This test server is a oracle10g database on AIX server.In the test environment the mail works fine.

utl_tcp.open_connection(remote_host => 'test server',
remote_port => 25,
tx_timeout => null);

The same thing if i use in production environment, it does not work. The production server is a 9i database on a unix server.

utl_tcp.open_connection(remote_host => 'prod server',
remote_port => 25,
tx_timeout => null);

Does the 10g has option to host SMTP service as apposed to 9i?

View 12 Replies View Related

SQL & PL/SQL :: Email With Excel Attachment

Aug 4, 2011

I need the pl/sql procedure that sends email with excel attachment using utl_smtp.The email procedure should take the excel attachment file from my local directory.

View 6 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

Forms :: Email In Body But Not In Attachment

Jun 19, 2009

I am sending email with attachment (word, pdf) without any problem. Now what i want is, instead of attachment that pdf / word file should come in body part , like means in internet explorer pdf open inside the browser itself while surfing. so means as soon as user open email, content of word / pdf should display in body part. how can i do this. using forms 6i, and database 10g.

View 7 Replies View Related

SQL & PL/SQL :: Sending Email With PDF File Attachment?

Nov 23, 2010

How to Sending Email With PDF File attachment.

View 3 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

Forms :: Sending Email With Report In PDF As Attachment?

May 1, 2009

I have the following code to send an email with a report as an attachment via forms. everything is running fine.

Now i do not have a message body in the email, so my question is how do i add some text as an email body

if i add the following parameter, its not working

ADD_PARAMETER(thelist, 'BODY',TEXT_PARAMETER, 'Check the attached Report');
DECLARE
report_id REPORT_OBJECT := find_report_object('checklist');
report_message VARCHAR2(100) :='';
rep_status VARCHAR2(100) :='';

[code]....

View 6 Replies View Related

SQL & PL/SQL :: Email With Attachment / How To Remove Empty Line

Jun 22, 2010

I need to send email notifications with attachments. Below is my testing codes.

declare
text varchar2(32000);
crlf VARCHAR2(2) := chr(13)||chr(10);
begin
text := 'Test only'||crlf||'test 2'||crlf||'test 3';
UTL_MAIL.SEND_ATTACH_VARCHAR2(
[code]......

I notice that, there is an empty line at the top of the content of this file. I don't want the empty line to be included in my file.

View 4 Replies View Related

PL/SQL :: Adding Image As Attachment To Email UTL_SMTP?

Jun 21, 2013

I am trying to add an image as attachment to an e-mail.

I am reading the image from the table and then passing it as a BLOB in my procedure.

Following is the part of the code which adds the attachment

{code}
PROCEDURE add_mail_attachment
(
/*

[Code].....

View 10 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

Workflow :: R12.1.3 Sourcing Award Approval Notification - Email Attachment

Oct 9, 2013

I have a requirement where I have to show attachment in R12.1.3 Sourcing Award Approval Notification.I am able to achieve this by adding #ATTACHMENTS attribute in the message and Attachment appears in the Notification in the E-Business work list but somehow its not appearing in "e-mail notification". 

View 0 Replies View Related

Application Express :: Change Content-disposition In Email Attachment?

Sep 17, 2013

I am using apex_mail (in Apex 4.1) to send emails with an attachment.

v_mail_id := apex_mail.send(
p_to => 'somebody@gmail.com'
...etc...
);
apex_mail.add_attachment( p_mail_id => v_mail_id
,p_attachment => v_image
,p_filename => 'signature.jpg'
,p_mime_type => 'image/jpeg');

Apex creates this as an attachment:

Content-Disposition: attachment;

I would like to change it to inline:

Content-Disposition: inline;

so I can reference it in my email body with <img src="cid:signature.jpg"/>. Well... I hope it is going to be shown inline anyway if I change Content-Disposition.

Currently (with Content-Disposition: attachment;) it works for Outlook, but, for instance, not in Gmail in the browser. Gmail shows the image separately as an attachment.

Is there a way to change the content-disposition with Apex?

I know it is possible to do it with utl_mail, but this is currently not installed in our databases. I need to involve our DBA to set this up, and I don't know if he is willing to do that.

View 2 Replies View Related

SQL & PL/SQL :: Sending Excel Attachment Through Oracle

Nov 23, 2010

i am able to send text/ csv attachment thru oracle PL/Sql Procedure. But i am facing this for excel attachment, some junk character is coming while opening that attachment excel file.

i am attaching here with my coding for your view. Anything i have to configure at my SMTP server.

View 5 Replies View Related

How To Send BLOB In Attachment In Oracle 10g

Feb 16, 2013

Actuall we requried to send and email from Oracle 10g database having attachements big in size aprox 10 to 30 MB.Is there any Custom Procedure or standard procedure for this.

We are using UTL_SMTP and UTL_MAIL (Only support RAW attachement upto 32 k in size).

View 3 Replies View Related

SQL & PL/SQL :: Error While Sending Text File As Attachment From Oracle 10g?

Sep 24, 2010

I've written a pl/sql to send mail. It works fine. Now i want to modify it to send an attachment txt/scv/xls file.This file is residing on client's pc.How to do it?

Following is pl/sql for sending mail.

create or replace PROCEDURE SEND_MAIL(P_SENDER IN VARCHAR2,P_RECIPIENT IN VARCHAR2,P_MESSAGE IN VARCHAR2,P_SUBJECT IN VARCHAR2 )IS
MAILHOST VARCHAR2(30) := 'MAILHOST.TIFR.RES.IN';
MAIL_CONN UTL_SMTP.CONNECTION;
BEGIN
MAIL_CONN := UTL_SMTP.OPEN_CONNECTION(MAILHOST, 25); -- TYPICALY 25 S THE PORT NUMBER FOR INCOMMING SMTP REQUESTS ON YOUR SMTP MAIL HOST
UTL_SMTP.MAIL(MAIL_CONN, '<'||P_SENDER||'>'); -- THE '<' AND '>' DEPEDS ON WHAT TYPE OF SMTP MAIL HOST U'RE RUNNING THIS ONE'S A NETSCAPE SMTPHOST

[code]......

View 2 Replies View Related

Windows / .NET :: Microsoft Access Attachment Field And Oracle

Oct 1, 2012

I'm using Microsoft Access 2007 as a front end to Oracle 10g tables using an ODBC Connection. I need to be able to add attachments to the records in one of my linked tables to hold emails, screen shots, log entries etc.

Access 2007 handles this capability with a field format called Attachment. I don't want to store the attachments locally but want them to be stored in Oracle, but I'm not sure what format the field in Oracle needs to be so that it will come across in Access as an Attachment field.

View 2 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

Getting Name In Email Address (Oracle SQL Plus)

Nov 6, 2007

How do I select the name in an email address. I would like to be able to order a list of email addresses by the name of the person ie. what comes before the @ sign.

So is there a query I could use to get everything before the at line . So in pseudocode I would need to be able to do something like this.

select substr(email, indexOf(@)+1,email.length) from table order by email

So I how could I go about doing that?

View 2 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

Saving Email In Oracle DB

Aug 23, 2011

if it is possible to save an email send from an ORACLE pl-sql packages in the Oracle database it self? The email is in my case created and send directly using the oracle utl_smtp-package.

I have no problems with attaching doc's and so on in this mail. But i simply cannot find a way to save, the email i'm sending in the Oracle-database. The purpose of saving the email in the DB is that i want to be able to reopen an send email, to se exactly what was send.

View 5 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

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

SQL & PL/SQL :: Return Receipt In Oracle Email

Jul 8, 2013

I have a requirement to use the return receipt functionality (how it exists in Microsoft Outlook emails)I tried with UTL_SMTP - using one of the 'Return-Receipt-To: abc@example.com', It is not working though.Rest of all features like cc, bcc works well.

Even I tried to use this with UTL_MAIL.SEND - I did not see this functionality in syntax itself.

View 6 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 :: Email Send From Oracle 6i?

Jun 25, 2012

tell the setting and code how send email through oracle?

View 4 Replies View Related

SQL & PL/SQL :: Email Notification Using Oracle Advance Queue

Nov 28, 2012

I want to send an email notification using oracle aq for events like when a message goes to error queue. Similarly,Can I send an email notification when I create a queue or drop a queue?

How can I do this?

View 3 Replies View Related

SQL & PL/SQL :: Displaying PDF File In Email Through Oracle Procedure?

Jan 29, 2012

We need to display a pdf file in the email generated through the oracle database procedure.

We created a blob object to store the pdf file and it is working fine then we created a package to read the file and display it but when i am running the procedure from the sqlplus prompt the following message is appearing

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.OWA_UTIL", line 377
ORA-06512: at "WHADMIN.IMAGE_GET", line 14
ORA-06512: at line 1

i am copying the procedure and package that i created for the same

create table demo
( id int primary key,
theBlob blob
)
declare
l_blob blob;
l_bfile bfile;

[code]....

when i am running image_get.pdf(1) from sqlplus prompt following error message is displayed on the screen

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.OWA_UTIL", line 377
ORA-06512: at "WHADMIN.IMAGE_GET", line 14
ORA-06512: at line 1

View 4 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

Application Express :: Sending Email From 4.0 With Oracle 11g Ee

Dec 11, 2012

I the past when working with apex 3 I was able to work with apex mail send very nice. In apex 4.0 with oracle 11g ee I'm not able to send emails anymore.

Last error message in the queue is:

ORA-29279: SMTP permanent error: 550 through this server without authentication.

the smtp server has not been changed, the code is fine. How I can go further?

View 20 Replies View Related







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