Forms :: Send SMS And Mail Through 6i?
Feb 17, 2012how can i send sms and mail through d2k 6i form?
View 14 Replies
ADVERTISEMENT
SQL & PL/SQL :: How To Check Availability Of Mail Server For Send Mail
Jul 28, 2012I m using UTL_SMTP to send mail using my mail server. could i check the availability of 1st mail server, if not available then could i set alternate mail server.
View 7 Replies View RelatedForms :: How To Send Mail With Attachment
Jun 7, 2010How to send mail with attachment ?
View 2 Replies View RelatedForms :: How To Send Reports From D2k Form To Mail
Jul 21, 2011How to send reports from d2k form to mail.
View 1 Replies View RelatedForms :: How To Send Mail To Lotus Notes With Attachment From Oracle Forms
Feb 7, 2011Query :"how to send mail to lotus notes with attachment from oracle forms"?
View 2 Replies View RelatedSend Mail Using SQL
Feb 23, 2009I want to send mail using plsql.I know that this can be possible by UTL_SMTP package.So I went thro some doc's & I tried this code :
PROCEDURE send_test_message
IS
mailhost VARCHAR2(64) := 'mailhost.fictional-domain.com'; /*(my computer name)*/
sender VARCHAR2(64) := 'prasadsug@yahoo.com';
recipient VARCHAR2(64) := 'prasadsug@rediffmail.com';
mail_conn utl_smtp.connection;
BEGIN
mail_conn := utl_smtp.open_connection(mailhost, 25);
utl_smtp.helo(mail_conn, mailhost);
[code]....
I got 'ora-00900:INVALID SQL STATEMENT'. which line i've done the mistake .how to rectify that?.
PL/SQL :: How To Send A Mail
Aug 6, 2013I have a requirement how to send a mail from pl/sql procedure and that mail content will be in HTML format and the data i have to fetch from one table
View 2 Replies View RelatedSQL & PL/SQL :: How To Send Mail From Oracle
Jul 26, 2011I had a question :
How to send mail from Oracle ??
Implement utl_mail??
How to implement ?? , or have any examples for reference??
Send ORA-error Alert Through Mail?
Feb 20, 2011how to create trigger or procedure for send all ORA- error alert mail from database. if any ORA - error comes in ALERT_SID.log then after trigger send the mail to my mail id
View 4 Replies View RelatedSQL & PL/SQL :: How To Send Mail From Oracle Database
Jun 21, 2013i want to send mail from database for this
C:UsersAdministrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Jun 21 16:03:04 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys@orcl as sysdba
Enter password:
Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name from v$database;
NAME
---------
ORCL
SQL> @ F:oracleproduct10.2.0db_1RDBMSADMINutlmail.sql
[code]....
SQL & PL/SQL :: Send Mail With XML File Attachment?
Sep 24, 2010i want to send mail with xml attachment.i create a procedure to send mail, when i send pdf,text file, they are open properly but if i send xml file i does not open...
/* Formatted on 2010/09/24 15:25 (Formatter Plus v4.8.8) */
CREATE OR REPLACE PROCEDURE apps.send_mail
AS
p_sender VARCHAR2 (80)
:= 'my@company.com';
p_recipient VARCHAR2 (80)
[code]....
SQL & PL/SQL :: Unable To Send Mail Using UTL SMTP
Mar 6, 2013I 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.
Send CSV File As Attachment In Mail PL/SQL
Mar 15, 2011Send a CSV file as attachment in a mail PLSQL. MY CSV file is already present in server. I just need to pickup that file and send the same as mail attachment.
View 1 Replies View RelatedSQL & PL/SQL :: Send Output As Xls Sheet In Mail
Jan 9, 2012give procedure that sends mail as an attachment. I have a query.. It should send the output as a xls sheet in the mail.
View 1 Replies View RelatedSQL & PL/SQL :: Send Mail As HTML Format In Oracle?
Mar 23, 2012I want to send the mail as HTML format in oracle.
The email message column is in clob datatype .
if i click the column it shows the text output(various tags ,symbols)
if i click the HTML it shows the correct format .,
i m sending the mail using that message column .,the mail Received with the text format ,actually i need it in the html format., How to send HTML output?
SQL & PL/SQL :: Send Mail From Procedure With Attach From File System
Apr 5, 2011I can send mail with UTL_MAIL using this:
CREATE OR REPLACE PROCEDURE send_mail_file_seti IS
BEGIN
UTL_MAIL.SEND_ATTACH_VARCHAR2(
sender => 'mail@from.com',
recipients => 'mail@to.com',
message => '<HTML><BODY>See attachment</BODY></HTML>',
[code]........
What I want to do is send mail attaching a file from file system. For example, I have this file:
/oracle/pmp/file
I want to send it using a procedure like the one above.
SQL & PL/SQL :: Sending Mail Through UTL_SMTP / Unable To Send CLOB In It
Sep 14, 2010I am sending mail thru UTL_SMTP. But i am unable to send the CLOB in it.If i break the CLOB into varchar2 then also it doesn't work.
Variables:-
vBuffer VARCHAR2 (4000);
l_amount BINARY_INTEGER := 4000;
l_pos PLS_INTEGER := 1;
l_clob_len PLS_INTEGER;
[code].....
While using the write_data procedure it is giving error as "Invalid OPeration"...how we can send the mail with CLOB.
Application Express :: Send Mail To GMAIL With Attachments
Feb 25, 2013I am able to send mail to Gmail from APEX. How an attachment can be send along with it.
View 6 Replies View RelatedSQL & PL/SQL :: Get Result Query Of Three Columns And Pass Into Send-mail Proc?
May 10, 2011I had never done this before, basically I need to get the result of the SQL query which had three columns and pass into thesend _mail proc, should I build a variable to hold the 3 value and send mail from it?
below is my send_mail proc
Quote:
CREATE OR REPLACE PROCEDURE SEND_MAIL (
msg_to varchar2,
msg_subject varchar2,
msg_text varchar2 )
[code]...
and below is my sql query
Quote:
select a.id, b.hr_info, c.details
from contact a, employees b, grid c
where a.id=b.id
and b.hc=c.hc
Forms :: Sending Mail With Attachment?
May 5, 2010i am using oracle forms 9i and i want to send a mail with attachment.
View 1 Replies View RelatedForms :: Sending Mail Through Oracle 10g
May 21, 2008Below 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].........
Forms :: Send SMS Using Oracle 6i
Feb 4, 2013I have successfully implemented the from which I can send SMS using Forms 6i and any mobile modem connected with OS.Now you can send SMS using Oracle Forms 6i.
View 15 Replies View RelatedForms :: Send Email Through 6i?
Nov 11, 2011i want to send email and message on mobile phone through forms 6i.
View 1 Replies View RelatedForms :: Oracle 6i Send SMS Through GSM Modem?
Jun 29, 2012i want to send sms through gsm modem in oracle form 6i.
View 3 Replies View RelatedForms :: Send SMS From Attached Mobile?
Mar 25, 2009is 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.
Forms :: How To Send Email From Oracle 10g
Sep 27, 2011I wanted to send email from oracle 10g forms at any hotmail,yahoo and gmail so how can i send.
View 16 Replies View RelatedForms :: 10g - Send Email From Application?
May 28, 2013I 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 !!
Forms :: Email Send From Oracle 6i?
Jun 25, 2012tell the setting and code how send email through oracle?
View 4 Replies View RelatedForms :: Report Without Viewing Send To Printer?
Jun 14, 2012WHEN-BUTTON-PRESSED
declare
repid report_object;
v_rep varchar2(200);
CNT NUMBER:=1;
ATC VARCHAR2(30);
[code]...
My issue is i have 3 locations(Area) following report run only at in house where AS Located i want to run this report at every location.
Forms :: How To Send Pic And TEXT In Email Using PLSQL
Jun 13, 2010I 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 ?
this code of image
<p align="center"><img border="0" src="logo.gif" width="20" height="20"></p>
I Think the problem of this code because 'Content-type: text/html' not image ?????!!!!!!!
utl_smtp.data(v_Mail_Conn, 'MIME-Version: 1.0' ||CHR(13)|| CHR(10)||'Content-type: text/html' || CHR(13)||CHR(10)||mesg);
procedure
EMAIL_SEN VARCHAR2(250);
EMAIL_REC VARCHAR2(250);
DESC_EN VARCHAR2(250);
UB_SEQ NUMBER(10);
BEGIN
DECLARE
v_From VARCHAR2(80) :=admin@yahoo.com ;
[code].........