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
ADVERTISEMENT
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
Apr 4, 2013
I m executing below PLSQL procedure . Its getting executed successfully but not displaying the O/P. I have set serveroutput on also.
set serveroutput on
DECLARE
lc_file_handle UTL_FILE.file_type;
lc_file_dir VARCHAR2 (100);
lc_file_name VARCHAR2 (50);
[code]...
View 14 Replies
View Related
Dec 9, 2010
Need info regarding sending an excel file attachment from plsql.I am using utl_smtp package in procedure and want to attach some sql query results in excel file.Is it possible to use sql query in same stored procedure that i am using to send the email attachment or i need to use external directory path to load the file as attachment.
View 9 Replies
View Related
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
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
Oct 11, 2010
How to send email in HTML format as an attachment/email body by executing oracle anonymous procedure
View 1 Replies
View Related
Dec 6, 2011
I have written a Java class which generate and place the XML file in a particular location. This the java class is loaded into Oracle using the loadjava command. When I call the sql java procedure java classn will be called and the XML file is generating.
But my problem is with xml header i.e in the header it is getting as
<?xml version = '1.0' encoding = 'UTF-8'?>
Where as I am generating the xml file from by just java call instead from Oracle the header is as follows
<?xml version="1.0" encoding="UTF-8" ?>
I am thinking that this could be reason with different jar using Oracle side.
View 3 Replies
View Related
May 16, 2012
I need to execute a .sql file in an oracle stored procedure.
View 9 Replies
View Related
Nov 23, 2010
How to Sending Email With PDF File attachment.
View 3 Replies
View Related
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
Dec 29, 2010
send me the procedure for loading the data in an oracle table into an excel file.
View 5 Replies
View Related
Oct 24, 2013
I need to create an Oracle Stored Procedure to read a Flat file(pipe delimited) and load the data into an Oracle table. I believe the file should be located in any of the path as logged in dba_directories table or it can be anywhere on the local client machine?
View 14 Replies
View Related
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
Sep 20, 2013
how to write procedure to load the data into a table using xml as input parameter to a procedure and xml file is as shown below which is input to me.
xml version="1.0"?><DiseaseCodes><Entity><dcode>0</dcode><ddesc>(I87)Other disorders of veins - postphlebitic syndrome</ddesc><claimid>34543></claimid><reauthflag>0</reauthflag></Entity><Entity><dcode>0</dcode><ddesc>(J04)Acute laryngitis and tracheitis</ddesc><claimid>34543></claimid><reauthflag>0</reauthflag></Entity><Entity><dcode>0</dcode><ddesc>(J17*)Pneumonia in other diseases - whooping cough</ddesc><claimid>34543></claimid><reauthflag>0</reauthflag></Entity></DiseaseCodes>.
View 3 Replies
View Related
Apr 24, 2009
i am working with image. I have successfully stored image in oracle table. Now i want to display the stored image in oracle form 6i. There i unable to display the image although i have created the data block using the same table name as the data source.
View 9 Replies
View Related
Nov 12, 2012
can you to display a field with negative value
S -- format mask display both sing + and -
MI -- format mask display negative sign at end
PR --Returns negative value in <angle brackets>. and Returns positive value with a leading and trailing blank.
I want the output should display only leading negative if the value is negative. I have used S99990.99 as format Mask. but need output should display only leading negative if the value is negative.
View 1 Replies
View Related
Oct 6, 2010
I have successfully Stored image file in Oracle 10g Database Table using Forms 6i. But I cannot retrieve that image and display on Forms 6i. Image Item on Form is not a database Item.
View 8 Replies
View Related
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
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
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
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
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
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
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
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
Jun 25, 2012
tell the setting and code how send email through oracle?
View 4 Replies
View Related
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
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
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
