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


ADVERTISEMENT

Forms :: Sending Email Through 6i

Apr 4, 2011

How to send an email through oracle FORMS6i ?

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

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

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 :: Sending Email With PDF File Attachment?

Nov 23, 2010

How to Sending Email With PDF File attachment.

View 3 Replies View Related

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

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

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

Forms :: Send SMS From Attached Mobile?

Mar 25, 2009

is there any API / library available that allows to send msges from a mobile connected at usb port ?

i want to generate sms msges from the fetched records from the database.

or any way to communicate with mobile attached to usb/serial port.

View 12 Replies View Related

Forms :: Error While Running Report - File Not Dynamically Attached

Aug 1, 2013

I am doing steps to run report in Forms....

when I running command rwserver server=reportserver10g in command prompt I am getting orapls10.dll file not dynamically attached error...

Forms and Reports and Database in my system only(practice purpose).

View 1 Replies View Related

Forms :: Opening Form Has Attached Libraries Caused Form Close

Jul 19, 2010

If I open a form has attached libraries in form builder on windows7 it closed and give this message :

Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll

[code]......

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

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

Forms :: Error In Sending Emails From A Form

Jan 19, 2010

Am facing a problem in sending an email to certain group of people, if the recipient just one person it will work but if more it will not work, I tried to read every one as a single recipient through a cursor but it was not working, the following is the sending

v_mail=:control.test;
mail_pkg.send
( p_sender_email => 'test@test.com',
p_from => 'test@test.com',
p_to => mail_pkg.array(V_MAIL),
[code].......

:control.test data is quotes between to quotes for each address.

View 2 Replies View Related

Forms :: Sending Employee PayRoll Slip

Jan 21, 2012

I am looking to send all employees in the company their payroll slip directly to their email IDs, so I need to built a producer can :

1- Generate their slips and save it into PDF files with each employee number .
2- send an email message to each employee with his slip.

View 2 Replies View Related

Performance Tuning :: Syntax To Pass Hint To Emulate Good Attached Plan?

Aug 16, 2012

I have an APP that truncates tables and loads data, which in turn makes the stats stale. I ran the query advisor (see attachment) and of course it ecommends running stats or accept a profile.I really don't want to do that as it may cause a load on my DB.

In turn, I would like to consider having my APP team change the query to pass a hint to use the best query plan.syntax to pass the hint to emulate good attached plan? Or is this a bad way to proceed?

select /* INDEX FAST FULL SCAN PK_PLACEMENT_REQUEST_QUEUE */
sum(lastshares) as "ROSEN"
from nyeo.fix_exec_reports fer, nyeo.placement_request_queue q,
nyeo.nyeo_block_control bc
where fer.clordid = q.sequence_number
and q.blockid = bc.blockid
and upper(bc.deskname) like '%ROSEN%'

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

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

Forms :: Email To Multiple Recipient?

Dec 12, 2012

How can I send mail to multiple recipients using UTL_SMTP.

Separating recipients (TO list) with ';' (semicolon) is not working.

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







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