SQL & PL/SQL :: Sending Email With PDF Attachments With Size More Than 32K?

Feb 14, 2010

I have been working on sending an email with a pdf attachment.I succeeded in PDF attachments with size <32 K.The steps I Used :

1.created a directory 'EMAIL' that points to the directory containing my pdf file.

2.

declare
vInHandle utl_file.file_type;
flen number;
bsize number;
ex boolean;
l_Output raw(32767);
fname varchar2(30) := 'labels.pdf';
vSender varchar2(30) := some1@hct.edu.om';

[code].....

It send the email <32 k.But for >32 K it give me the error :

ORA-06502: PL/SQL: numeric or value error: raw variable length too long
ORA-06512: at "SYS.UTL_ENCODE", line 243
ORA-06512: at "SYS.UTL_MAIL", line 118
ORA-06512: at "SYS.UTL_MAIL", line 324
ORA-06512: at "SYS.UTL_MAIL", line 414
ORA-06512: at line 18

I know it has something to do with blob or clob ....where i can modify my code to work.

View 17 Replies


ADVERTISEMENT

Forms :: Sending Email Through 6i

Apr 4, 2011

How to send an email through oracle FORMS6i ?

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

PL/SQL :: Sending Email With Reply To Sender?

Sep 3, 2013

In the database there is a job that monitors the delivered date.5 weeks before this date a email is send.I this mail i would like to implement a notification button. the receiver will get a mail with notification:o Yes i will succeedo No, i wil not succeed this answer has to be send back to the sender . how to do this. note: the receivers can have different mail clients!

View 10 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 :: Error When Tried Sending Email Through Stored Procedure?

Jan 6, 2011

I have this stored procedure that does implements some business logic and then sends an email.

I got the below error when it tried to send the email

Quote:Returned values:
ERR_CODE =-29279,
ERR_MESSAGE = "MSS DATABASE INCONSISTENCYOTHERS EXCEPTION in XCOM_X080_SUBMITORDER - SQL -29279 SQLERRM: ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO""

How can I handle this error using exception and in case sending email fails instead of abnormal exit ?

View 2 Replies View Related

Forms :: Sending Email To Yahoo Or Gmail From 10g

Apr 23, 2010

How to send email from Oracle forms10g to a yahoo or gmail account using authentication.

View 5 Replies View Related

Forms :: Sending Email With Attached Files?

Jun 15, 2010

I am using the following code on a button and once I pressed the button the form disconnected.

Declare
Outlook_Object client_OLE2.OBJ_TYPE;
Mail_Object client_OLE2.OBJ_TYPE;
Item1 client_OLE2.OBJ_TYPE;
Item2 client_OLE2.OBJ_TYPE;
OLEPARAM client_OLE2.list_type;

[code]....

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

Usage Of UTL_HTTP - Sending Email With External Mail ID?

Apr 22, 2013

What is the usage of UTL_HTTP?

Will I be able to send e-mail with UTL_HTTP to an external mail id?

View 5 Replies View Related

Replication :: Sending Email To Administrator When Refresh Fails?

Apr 22, 2009

I have a refresh group that will refresh several materialized views at 4:00am. Sometimes the job failed. We need to enter to the enterprise manager to check the status of the refresh group.

Our target is that notification email is sent to our email once the refresh job failed. I have found some software that can do that. However, we need to handle ourselves. I would like to ask whether we can do that using enterprise manager.

View 7 Replies View Related

Sending Email Notifications / Alerts Via Enterprise Manager 11g

Feb 24, 2013

I have Oracle 11g on Linux...and i have set up SMTP of my Enterprise Manager Database control. I click on Test and an email was sent successfully. What i don't know is how to add more emails as the recipient of the alerts.

I have setup metrics like number of sessions, cpu usage, buffer cache hits, swapping, tablespace usage, etc...Upon saving and waiting for transactions to come in, alerts were shown the the EM homepage..but i did not receive any emails.

View 2 Replies View Related

SQL & PL/SQL :: Sending UTL_SMTP Mail With JPG Picture As Header Inside Email?

Oct 7, 2013

I have to embed a picture as a header with an e-mail content for my work, I google'd and tested with different options but I failed. (The JPG is stored in a table as a blog object) When I tried with the below code the JPG file is e-mailed as an attachment with an e-mail content, I want it to be displayed inside an e-mail.

I tried att_inline: TRUE option as well - still not working.

Here is my code I tested and worked as an attachment.

DECLARE
/*LOB operation related varriables */
v_src_loc BLOB :=EMPTY_BLOB;
l_buffer RAW(54);
l_amount BINARY_INTEGER := 54;
l_pos INTEGER := 1;
l_blob BLOB := EMPTY_BLOB;

[code]....

View 3 Replies View Related

Application Express :: When Email Sending Process Activated Pages Just Hang?

Aug 5, 2012

I have a system that has issues with sending some emails.

When the email sending process is activated the pages just hang.

Are there any logs or anything like that anywhere that i could look at to try and make sense of it.

View 1 Replies View Related

Test Instance With Oracle 11gR2 - EM Sending Email Notifications Too Late

Feb 18, 2013

On a test instance with Oracle 11gR2 with Enterprise Manager Database Control I try to activate the Email Notifications in Enterprise Manager, so that I can use them for monitoring.

So i configured following settings:

Under Setup -> Notification method I gave him a valid mail address with a vaild SMTP server. The test mail was send successfully.

Under Preferences -> General i gave SYS a valid mail address to receive. The execution plan i let in standard configuration, so every time at everyday i will get an email, when something happens. the test mail was send successfully too.

Now i created an own rule to test the configuration:

I went to Preferences -> Rules an add an rule. Name and description I named "test" and set "database instance". At availability I activated all checkboxed, so i should be informed when the instance goes down, comes up, getting an error, when the error is fixed, when agent is not available, when agent is available again, when there is a metric error, when the emetic error is fixed, when a blackout starts and when it ends.

Metrics, policies and jobs there wasn't defined anything in standard, so i let it so and set nothing here. I activate the checkbox for sending emails to sys and sending repeat emails every 15 minutes 3 times at all.

Now, to test this notification i logged into my testserver and killed the listener process, to see, what will happened. After 1 Hour waiting i didn't get any email, so i restarted the listener. after the listener was started my outlook was fluted by emails from the server, that the listener was down. But why i didn't get them earlier.

I checked the procedure with the database to, here i get it down by "shutdown abort" and "shutdown immediate". But i get the mails, that the database is down, when its up already. And thats to late!

When I want to use such email notifications for productive servers and someting is going wrong, for that a notifications is configured of course, I want to get the mail directly, when that happened and not, hen the problem is fixed!

For example, here an email from testing, where the listener was down, that i've get at 13:01 :

Target Name=LISTENER_<hostname>
Target Type=Listener
Host=<hostname>
Metric=Status
[code].........

View 2 Replies View Related

Application Express :: Send Mail To GMAIL With Attachments

Feb 25, 2013

I am able to send mail to Gmail from APEX. How an attachment can be send along with it.

View 6 Replies View Related

Workflow :: Send Attachments To Requester In AP Invoice Approval Workflow

Sep 4, 2012

We are on 12.1.3 Apps.

We want to be able to send attachments at the invoice header level with the invoice approval workflow email as attachments. The standard workflow does not provide this functionality.

We were able to achieve this functionality using the approach given here:

[URL]........

Basically we added a document type attribute to the notification message, and set a BLOB variable to it inside our custom procedure, which is set as the function for the notification: DOCUMENT_APPROVAL_REQUEST.

Now we are able to see the attachments coming as attachments in approval request emails to the approvers. But the issue is that the first approver on the list, the requester is not seeing the attachments. All the other approvers can see the attachments. We have checked the WF Role for the user and the Notification preference is set as MAILHTML

As far as i can see, same notification and same message is used to send the email to all approvers including requester. Then why only requester is not getting the attachments?

View 0 Replies View Related

Server Utilities :: Estimate Size Of FlatFile Based On Table Size?

May 8, 2013

We are planning to export the table data to a file pipedelimited. How do i estimate the size of the FlatFile based on the table size? or avg rowlength

View 3 Replies View Related

Server Administration :: How To Reduce Size Of TEMP DBF File Size

Apr 13, 2011

I am using oracle 8.1.5 database and my temp01.dbf file size is increased upto 19.8 GB now i want reduce its size .

View 13 Replies View Related

SQL & PL/SQL :: Sending PDF Through Mail?

Feb 16, 2010

I have written a procedure to send a pdf file through mail. The directory was created and registered in SYS.DBA_DIRECTORIES with read,write grant access. But im getting the below error.

******
ORA-20014: Error in MAIL_FILES_PRO ORA-20012: Invalid Operation
ORA-06512: at "ANAND.PRO_ICTPAYSLIPMAIL02", line 229
ORA-06512: at line 2
******

View 7 Replies View Related

SQL & PL/SQL :: Sending SMS Through Oracle Database

Sep 16, 2006

I have a Database of My all customers Mobile Nos I want to send SMS to all customer from Oracle Database using Pl/SQL or any inbuilt Oracle Package, if available or through Oracle forms

How i can send SMS to my Customers through Oracle PL/SQL or Oracle forms or any other front end and what are the additional requirement in sending SMS and what utilities are needed .

View 7 Replies View Related

Sending / Converting From CLOB

Jun 15, 2012

We are able to insert CLOB into database, Using oracle Text I'm able to search inside clob. [two questions solved ]. The question arise when we need to send this data to application either as file or as text(varchar2).

I'm able to generate file from CLOB using function,unfortunately it resides inside db and developer is not able to access it.

1)There is option to mount application partition inside db and export file over there but it is not viable option according to management.

2)I've Googled the solution to create JAVA API. Which will perform OS command like scp to send file from db to app(or any remote host). For security reason this option is also dropped.

3)I tried dbms_lob.substr but actual text inside clob is too long. File generated from CLOB sized around 5 MB.

So I guess it requires lot of effort if I wanted to convert into varchar2 as out parameter inside function.

So, to give CLOB data to developer as file or as varchar2. I'm not able to get any solution. Is there any other option using database to convert to string/varchar2 from CLOB ? Or do I need to drill down more into third option.

I'm having oracle 10.2.0.5.

View 2 Replies View Related

SQL & PL/SQL :: Mail Sending In DAT Format Instead Of HTML?

Oct 14, 2010

I have learned procedure to send email with html attachment using UTL_SMTP protocol. But I could see the mailed attachment shows .Dat format. I need the attachment should go in .Html format.

find the below code which i am using:

CREATE OR REPLACE PROCEDURE send_email(
pi_from in Varchar,
pi_to in VARCHAR,
pi_subj in VARCHAR,
pi_msg CLOB
)

[code].....

View 2 Replies View Related

SQL & PL/SQL :: Accountable Mail Sending To MTA Program

Mar 3, 2011

We currently send mail via UTL_SMTP, we could easily switch to SMTP_MAIL but that is beside the point.

Our issue is that we have no way to find out what happens to mail we send to the MTA program, "smtpd". It is of my knowledge that the only information we can receive back from UTL_STMP is if the email address is invalid or if the email is going to be attempted to be forwarded by the MTA "smtpd".

We need the REAL data behind the scenes that "smtpd" is going to get after it attempts to forward an email from the database to GMail for example. We need "account does not exist" errors, and anything else that Google might have to say about us sending that address mail.

As far as I have researched there are no out of the box ways to send mail in this fashion.Could this be as simple as specifying the MX server for GMail? So for an email to a GMail account instead of connecting to localhost:25 for our SMTP server, we should connect to mx.googlemail.com:25?

how to setup receiving bounce messages through the database? We currently receive mail at the database box, and I think we can specify a special clob that will open one of the incoming mail files in RHEL to read for bounces.

View 7 Replies View Related

SQL & PL/SQL :: Sending Arabic Sms To Gsm From Oracle Database

Jun 16, 2013

i'm trying to send Arabic sms to mobile but the the message come in this way "?

View 29 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 Alert Mail Based On Value?

Sep 21, 2012

I have a table with 4 columns

select * from temp

A B C D <- columns.

I have to send an alert mail based on the value of column C when its value is 50. It should be able to send mails 24x7

View 4 Replies View Related

Forms :: Sending Mail Through Oracle 10g

May 21, 2008

Below code working fine when i am using Forms6i. But i want to send a mail by Forms10g.

declare
objOutlook OLE2.OBJ_TYPE;
objMail OLE2.OBJ_TYPE;
objArg OLE2.LIST_TYPE;
objAttach OLE2.OBJ_TYPE;

BEGIN

objOutlook := OLE2.CREATE_OBJ('Outlook.Application');

-- Previous example usually used 'mapi.session' but this doesn't work correctly
--anymore.

objarg := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(objarg,0);
objMail := OLE2.INVOKE_OBJ(objOutlook,'CreateItem', objarg);
OLE2.DESTROY_ARGLIST(objarg);
objAttach := OLE2.GET_OBJ_PROPERTY(objmail, 'Attachments');
[code].........

View 5 Replies View Related

SQL & PL/SQL :: Transient Error While Sending Mail

May 6, 2012

I just Found emailing code . so i tried to execute on my test database.

My Database Version : PL/SQL Release 9.2.0.1.0 - Production
My Toad Version : 7.2

Code I tried To Execute :

CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_to varchar2,
msg_subject varchar2,
msg_text varchar2 )
IS
c utl_smtp.connection;
rc integer;
msg_from varchar2(50) := 'Oracle9.2';
[code].........

While i execute procedure i get Transient Error..

This code is look like simple, then whats problem, because i m not attaching any file also...then why this error occurred.

View 1 Replies View Related







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