SQL & PL/SQL :: Unable To Send Email From Oracle XE?
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
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.';
I have to send several reports to various branch via email, I created a branch table in which email of that branch is stored in a column. Now if report is generated for particular branch, its PDF should also be sent via email to that branch, How can this be done on When Button Pressed,
I am succeeded to send mail (through my comapany mail server) using following pl/sql. But, i am unable to send mails using the same coding, when i connected to smtp.gmail.com. i received the following error :
ERROR at line 1: ORA-29279: SMTP permanent error: 530 5.7.0 Must issue a STARTTLS command first y78sm463148pyg ORA-06512: at "SYS.UTL_SMTP", line 17 ORA-06512: at "SYS.UTL_SMTP", line 98
[code]...
Then I received the following error message: ERROR at line 1: ORA-29278: SMTP transient error: 454 TLS not available due to temporary reason ORA-06512: at "SYS.UTL_SMTP", line 17 ORA-06512: at "SYS.UTL_SMTP", line 96
[code]...
my demo_mail package body coded as
FUNCTION begin_session RETURN utl_smtp.connection IS conn utl_smtp.connection; BEGIN -- open SMTP connection
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
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.
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.
I am create procedure send the message in form bulider10g to Internet email and the procedure is work .
but now I want to modify this procedure , I want to add picture of my country ( logo ) and the original message . why cant display the image in my email ?
i have installed oracle application server forms and report services, and i am deploying my forms and reports on it and its working fine, now i have a new requirement to send email through reports. I am already generating reports on pdf form and displaying on screen. How can i send this report PDF as an attachment and send it to different email addresses or how can i setup oracle application report services to send emails as an attachment.
I'm attempting configure User-defined Metric to send mails when happen warning or critical alerts .My environment is Cluster Database and I'm using OEM Grid Control
I created User-defined Metric for monitoring invalid object for example and scheduled this collect to every 5 minutes.On initial OEM page, I see alert violation, but don't receive mail for this. In my Notification Rules page, I added "User-Defined Numeric Metric" and includes object Check_Invalid_Objects, wich is my UDM.I receive several alerts violations, but don't UDM.
UDM_Violation.png ( 116.68K ) Number of downloads: 0
NotificationRule.jpg ( 218.78K ) Number of downloads: 0
ScheduleNotification.jpg ( 373.64K ) Number of downloads: 0
This set is returned based upon some criteria mentioned in the where clause of the SQL.Ultimate aim is to send 1 notification to each of the email id's and those notification should have the corresponding attribute values. 3 notifications fired from a workflow triggered by the concurrent program (which actually returns this 3 rows in a SQL)Supplier 1 to receive 5000Supplier2 to receive 4000Supplier3 to receive 3000 My approach / or the only approach coming in mind is using a cursor for the SQL inside the concurrent program and using a for loop, initiating the workflow each time for a loop iteration i.e for each iteration of loop , workflow procedure will need to be initiated, so item type will be same but item key will of 3 different item key. is it somehow possible to fire only one instance of workflow and not 3 different instances to send 3 notifications. Ad hoc role creation would not be option here because the number of rows may be large and not just 10-15.
I have a ORACLE 10g(10.2.0.1.0) database that I am running on windows. I have export backups batch file running every day through windows scheduler. I would like to know If there is some way that sends me an email after the backup is finished and also send me if it does not finish with error.
I have successfully done this om my SQL Server machine but don't know for ORACLE as I have not purchased it and have license
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?
SELECT DAY_NBR ||' '||HOUR_NBR ||' '||MINUTE_NBR AS "@TIMEPOINT", RTRIM ( xmlagg (xmlelement (c, procedure_nm || ', ')).extract ('//text()'), ', ' ) AS "@LABEL", RTRIM ( xmlagg (xmlelement (c, procedure_id || ', ')).extract ('//text()'), ', ' ) AS "@PROCEDURE_ID", cursor (SELECT SUBJECT_NBR AS "@LABEL",TO_CHAR (PSUB.procedure_tm,'HH24:MI') AS "@TIME", PROCEDURE_ID AS "@PROCEDURE_ID", PROCEDURE_SUB_ID AS "@PROCEDURE_SUB_ID" FROM PROCEDURE_SUBJECT_TIME PSUB WHERE PSUB.ACTIVE_FLG = 1 AND PSUB.PROCEDURE_ID in pr.PROCEDURE_ID ORDER BY PSUB.procedure_tm,PROCEDURE_ID )AS VOLUNTEER FROM SCHEDULE_PROCEDURE PR WHERE active_flg = 1 and SCHEDULE_ID = 200900195269 group BY day_nbr,hour_nbr,minute_nbr,procedure_nm;
and the error getting is ORA-00979: not a GROUP BY expression
I am using utl_smtp to send emails. I am getting the below error message.
Error in XX(Package name) ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO" at - 5150 Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200 Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200 Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7200 Error in XX(Package name) ORA-29277: invalid SMTP operation at - 6000 Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7250 Error in XX(Package name) ORA-29277: invalid SMTP operation at - 8450.
I have checked the mail id in the "TO" list and found them to be valid. Is there could be any other reason? I have run this package in test instance and it is working fine. I am able to receive mails. In the test instance, I have put my mail id in the to list.
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).
