Personnel
Someone has an example of a procedure that sends automatic e-mail by Oracle from a .log file from an Oracle backup.
For example, I scheduled several exportations for my DB, every day he does. so I wanted every day to get the log file of this export and automatically send to my email ..
does anyone have a script of this?
valeu
Fernando
Script for sending e-mail
-
- Rank: Programador Júnior
- Posts: 16
- Joined: Thu, 16 Aug 2007 9:05 am
- Location: são caetano do sul - SP
Keen On Oracle - DBA
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
I do not have this script, but I think the ideal in this case is you to create a shell that makes the service and schedule it in the crontab. (this if it is * ix)
-
- Moderador
- Posts: 2016
- Joined: Wed, 12 Jan 2005 3:25 pm
- Location: Araraquara - SP
Abraço,
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP
Brothers,
I found a script, which I put below, but I did not have the opportunity to test it here.
follows the code for analysis:
Send_attach_raw
Represents The Send Procedure Overloaded for Raw Attachments
]]
SEND_ATTACH_VARCHAR2
Represents the Send Procedure Overloaded for Varchar2 Attachments
99]] Source: http://www.psoug.org/library.html
I found a script, which I put below, but I did not have the opportunity to test it here.
follows the code for analysis:
Send_attach_raw
Represents The Send Procedure Overloaded for Raw Attachments
]]
SEND_ATTACH_VARCHAR2
Represents the Send Procedure Overloaded for Varchar2 Attachments
utl_mail.send_attach_varchar2(
sender IN VARCHAR2 CHARACTER SET ANY_CS,
recipients IN VARCHAR2 CHARACTER SET ANY_CS,
cc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
bcc IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
subject IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
message IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL,
mime_type IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT 'text/plain;
charset=us-ascii',
priority IN PLS_INTEGER DEFAULT 3,
attachment IN VARCHAR2 CHARACTER SET ANY_CS,
att_inline IN BOOLEAN DEFAULT TRUE,
att_mime_type IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT
'text/plain; charset=us-ascii,
att_filename IN VARCHAR2 CHARACTER SET ANY_CS DEFAULT NULL);
Same as SEND_ATTACH_RAW except that the attachment must be an ASCII text file.
99]] Source: http://www.psoug.org/library.html
-
- Information
-
Who is online
Users browsing this forum: No registered users and 5 guests