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


ADVERTISEMENT

Application Express :: IR Does Not Recognize The Application Item Content Correctly

Aug 22, 2013

I have an application item that receives a web service result. This result is like 'MARIA','JOSE','JESUS'. I'm using this string into the parameters of the interactive report, but this is not recognized. I'm showing the content of the application item into a pl sql region and the content is 'MARIA','JOSE','JESUS', when I include this application item into the query, the IR shows me 'MARIA','JOSE','JESUS' 

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

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

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

Application Express :: Scrollable Content Region - Template?

Jul 31, 2013

I have just implemented a "Data Load" function which is the OOTB page type in apex 4.2 which allows the end user to go through a wizard and import csv data into a table.

 When the user is viewing the data to be imported - they have to scroll across the length of the screen (depending on how many columns you are loading). I noticed there is a Region template called "Scrollable Content Region". I tried applying this template to my region, and when this didn't work, to a container region. 

The scrollbars appear (horizontally and vertically) but they are greyed out as the region is still at max width and you have to use the browser to scroll instead.I think this looks untidy as the header colour-styling ends, as well as other regions being stretched.

View 3 Replies View Related

Application Express :: Function Returning Blob Content

Sep 10, 2012

I am using the below function to return a blob (CSV) content, this is working fine..But i need to modify this function to display headline for the report and fixed width column in CSV ( then user no need to expand the each and every column ).

create or replace function GET_BLOB (
p_query varchar2
) return blob as

l_cursor integer;
l_cursor_status integer;
l_col_count number;
l_desc_tbl sys.dbms_sql.desc_tab2;
l_col_val varchar2(32767);
[code]....

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

Application Express :: Theme 25 Content Frame - Does Not Display In IE Compatibility View

Mar 20, 2013

Environment:_
APEX Version 4.2.0.00.27
Theme 25

I have a number of pages that use the page template "*One Level Tabs - Content Frame*".End users that use Internet Explorer (versions 8 and 9), when they first visit the application their browser displays it in Compatibility View.They cannot see the side bar on the right-hand side, meaning that often they cannot see a lot of necessary buttons and info!

Their page displays as below: URL....

I am not sure it is possible, nor good practice, to force the app to display in non-compatibility mode.Is there a way to enhance their experience? Or another workaround?

At the moment I am waiting until they log an issue and then informing them to turn compatibility view off, or to use Chrome or Firefox. I'd like to make it better from my end!

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

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

PL/SQL :: Storing File In Blob Object And Publishing Content As Email?

Jun 14, 2013

Oracle Database Version: 11.2.0.2.0

We have a requirement below:

The basic requirement is to send an email to the user about order information, with specific subject and the corresponding e-mail body.

Here the E-mail body is very exhaustive, so we are asked to store the content of the e-mail in a word document and store this word document in a tables column of type BLOB.

Once we store this file in the BLOB column, when we send the e-mail to the customer we need to publish the content of the file in the e-mail body and send the e-mail to the user (This E-mail body has some dynamic content as well, that needs to be generated on the fly). This e-mail sending part is done by the shell script.

How can i publish the content of the BLOB object in the e-mail body.

View 9 Replies View Related

Application Express :: Email Not Working After 4.1 Upgrade

Jun 11, 2012

O/S: Windows 2003
DB: 11gR1

Email no longer working for users after upgrading from 4.0 to 4.1. New 'principal' APEX_040100 added to same ACL as previous version's principal APEX_040000. In fact, both still exist in ACL.

Error code in APEX Admin Mail Queue: ORA-24247: network access denied by access control list (ACL)

What could be causing the email facility within APEX to no longer work?

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

Application Express :: Email 4.2 Chart As Inline Image

Aug 20, 2013

I have created a few flash charts using APEX4.2.  Is there a way for the user to view the chart and then email it as an inline image to someone? I know that the user can save the chart as PDF file, then send it as an attachment via Outlook ( or similar system), but can I integrate these manual steps to one ( template), similar to the IR report's download feature ? 

View 0 Replies View Related

Application Express :: Changing Sequence In Content Frame Not Changing Ordering Of Regions

Apr 24, 2013

Using Application Express 4.2.1.00.08

Any problem using 4.2's One Level Tabs - Content Frame page where you have a parent region (of type content frame Body Container ) while number of child regions (of type Hide & Show Region - Borderless ), if you want to re-order them by changing the sequence, it has no effect when you run the page.

The regions still show in the same order top to bottom as it did before the update of sequences. Heading links (to show/hide child regons in content frames) has the same ordering as before.

View 3 Replies View Related

Application Express :: In Apex Email Unable To Attach More Than 32kb Of Data

Aug 20, 2013

I have issue with application ,When I am trying to upload any a csv file of 3 MB in email through apexIts only uploading 32Kb of data remaining is ignoring for more then 32kbMay I know why this issue is and is there any process or methods to track this. I am using the apex version (Application Express 4.1.1.00.23).

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

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

Application Express :: How To Change File Character When Export Application (4.2.1.00.08)

Feb 5, 2013

I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with

"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",

how can I do change it?

View 1 Replies View Related

Application Express :: Way To Change Application Builder Theme

Sep 24, 2012

Is there a way to change the Application Builder theme? There are themes for applications; how about for the builder itself? I looked but did not see a selection for this.

I'm a Geek thru and thru, I guess, but I think you might have to be xxxx retentive to like all these square boxes. And these old eyes have to squint to focus among the vast sea of gray shades.

View 2 Replies View Related







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