SQL & PL/SQL :: Create Large CSV And Send It As Attachment

Jun 22, 2012

Can i send a large file( over 1 million) as email attachment as .CSV file...?

I have a requirement to send a large file ".CSV" when the procedure / package is invoked as email attachment. The data in the CSV file is pulled from a table (as below).

(1) I tried below code to execute "send_email" which is uses utility UTL_SMTP. It is working fine with
100000 records and getting an email attachment with .csv
(2) If more 100000 i am not getting any email / attachment.

I am looking forward to send a huge data like 1 million.
>>>>>>>>>>>>>>>>>>>>>
DECLARE
l_clob CLOB;
l_attach_text VARCHAR2 (32767);
l_attach_text_h VARCHAR2 (32767);
Cursor c1 is
SELECT LOCATION,PARTY_NAME,ADDRESS1,CITY,STATE_PROV,COUNTRY,POSTAL_CODE FROM emp_table;
[code].......

View 11 Replies


ADVERTISEMENT

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 :: How To Send Mail With Attachment

Jun 7, 2010

How to send mail with attachment ?

View 2 Replies View Related

SQL & PL/SQL :: Send Mail With XML File Attachment?

Sep 24, 2010

i want to send mail with xml attachment.i create a procedure to send mail, when i send pdf,text file, they are open properly but if i send xml file i does not open...

/* Formatted on 2010/09/24 15:25 (Formatter Plus v4.8.8) */
CREATE OR REPLACE PROCEDURE apps.send_mail
AS
p_sender VARCHAR2 (80)
:= 'my@company.com';
p_recipient VARCHAR2 (80)

[code]....

View 1 Replies View Related

Send CSV File As Attachment In Mail PL/SQL

Mar 15, 2011

Send a CSV file as attachment in a mail PLSQL. MY CSV file is already present in server. I just need to pickup that file and send the same as mail attachment.

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

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

PL/SQL :: Generate Excel File And Send It As Attachment

Apr 10, 2013

I have a requirement to send email with attachment using PL/SQL procedure of 10g database. We will be querying data from database, generating excel(csv) file and attaching to email. How can I achieve this goal.

I have a procedure that will send email as HTML but it has limitations of sending 32K data.

CREATE OR REPLACE procedure send_email(
p_to            in varchar2,
p_from          in varchar2,
p_subject       in varchar2,
p_text          in varchar2 default null,
[code]........   

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

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

SQL & PL/SQL :: Unable To Create Index On Large Table

Sep 30, 2012

I am trying to create a new index on large table of size around 100GB. but i am getting the following error:

ORA-1652: unable to extend temp segment by 128 in tablespace TEMP.

temp tablespace size is : 20 GB.

does it mean that the whole index will be created at temp tablspace first?

View 3 Replies View Related

Performance Tuning :: Create Small Functional Indexes For Special Cases In Very Large Tables

Apr 5, 2012

Create small functional indexes for special cases in very large tables.

When there is a column having one values in 99% records and another values that have to be search for, it is possible to create an index using null value. Index will be small and the rebuild fast.

Example

create index vh_tst_decode_ind_if1 on vh_tst_decode_ind
(decode(S,'I','I',null),style)

It is possible to do index more selective when the key is updated and there are many records to create more levels in b-tree.

create index vh_tst_decode_ind_if3 on vh_tst_decode_ind
(decode(S,'I','I',null),
decode(S,'I',style,null)
)

To access the record can by like:

SQL> select --+ index(vh_tst_decode_ind_if3)
2 style ,count(*)
3 from vh_tst_decode_ind
4 where
5 decode(S,'I','I',null)='I'
6 group by style
7 ;

[code]....

View 2 Replies View Related

SQL & PL/SQL :: Create Procedure That Will Send In Customer ID / Password And New Password

May 14, 2011

I am trying to create a procedure that will send in the customer id, password and new password. The procedure will say if it has been updated or not. this is the code i have.

--Patty Carson
--Assignment 3 Question 3
--Description: Allows the user to change a password for a customer
CREATE or REPLACE procedure ChgPwd
(custid OUT number, password OUT VARCHAR2, newpassword IN VARCHAR2)
AS
[code]...

View 15 Replies View Related

PDF Attachment From Apex Application?

Aug 8, 2011

I am using Apex 4.0.

We have a requirement to send the html contents saved in the CLOB column of a table as PDF attachment in the email from apex application. Currently we are sending the .htm file as the attachment from the apex application.

include the html contents as a PDF document with some small examples.

Currently I am using APEX_MAIL.ADD_ATTACHMENT to include the attachment and APEX_MAIL.SEND to send the mail. Currently we are sending the attachment in the .htm format.

The html data is present in the column of a table, which we are sending in the attachment as a htm file. Any example to send the PDF attachment using APEX_MAIL.ADD_ATTACHMENT.

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

Forms :: Sending Mail With Attachment?

May 5, 2010

i am using oracle forms 9i and i want to send a mail with attachment.

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

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

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

How To Remove Newline Character At Start In Attachment

Jan 9, 2013

I have been trying to attach a .dat file generated at an external source and send it as an attachment by mail using UTL_SMTP, all things are working but the .dat file which comes attached in mail contains a newline character i.e. chr(10) at the start line and the contents of the file are written from second line onwards. Below is some part of the code which deals with read/write of attachment of mail to be sent.

UTL_SMTP.write_data(c,
'Subject' || ': ' || P_SUBJECT || UTL_TCP.crlf);
UTL_SMTP.write_data(c,
'MIME-Version: 1.0' || UTL_TCP.crlf || -- Use MIME mail standard
'Content-Type: multipart/mixed;' || UTL_TCP.crlf ||
[code]....

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

SQL & PL/SQL :: Procedure For Sending Mail With Excel / Pdf Attachment Using Smtp?

Nov 24, 2010

send script to send mail with excel attachment using smtp from Oracle 9i

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

Application Express :: How To Make Default Attachment As CSV File Instead Of HTM

Oct 28, 2012

I am having an interactive report with an email subscription.

My question is, how can I make the default attachment as a .csv file instead of the .htm file?

View 2 Replies View Related

Application Express :: Attachment In Team Development Missing In 4.2?

Mar 14, 2013

I was waiting for the attachment in Teamdevelopment as stated in APEX 4.2 new Features:

Support for attachments within Team Development 1007 EA2 Allow file attachments for bugs, todo, and features.but I can not find the functionality?

View 2 Replies View Related

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







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