Re: How to send email from pl/sql in 806?

hi,
i've oracle 8.1.5 on NT. but could'nt find the utltcp.sql , infact it had the procedure utl_http
could it help?

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, May 25, 2001 1:56 PM

> hi sharma
> The builtin packages UTL_SMTP and UTL_TCP are available with oracle 8.1.5
> onwards , thats the reason you were getting compilation errors.
> Ramana
>
>
> > ----------
> > From: Saurabh Sharma[SMTP:saurabhs_at_fcsltd.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Friday, May 25, 2001 12:40 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: How to send email from pl/sql in 806?
> >
> > HI,
> > i tried creating this procedure. but it results into compilation
errors.
> > says..
> > utl_tcp.connection must be declared, and so does for
> > utl_tcp.get_line and
> > utl_tcp.write_line
> >
> > how do we fefine them. where is this package utl_tcp
> >
> > pls explore.
> >
> > thanks.
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, May 23, 2001 11:05 AM
> >
> >
> > >
> > > try this procedure it works just replace the IP address in the line
> > > c := utl_tcp.open_connection('192.168.1.1', 25);
> > > with the IP address of u'r mail server
> > >
> > > regards
> > > ______________________________________
> > > Omar Khalid
> > > Software Engineer
> > > LMKResources
> > > A LANDMARK AFFILIATE
> > > (Formerly Mathtech Pakistan Pvt. Ltd)
> > > 18, F-8/3, Main Margalla Road,
> > > Islamabad, Pakistan
> > > Voice: 111-101-101*780
> > > Fax: 92-051-2255989
> > > Email: okhalid_at_lmkr.com
> > > Web: www.lmkr.com
> > >
> > >
> > >
> > >
> > rem
> > -----------------------------------------------------------------------
> > > rem Filename: smtp.sql
> > > rem Purpose: Send e-mail messages from PL/SQL
> > > rem Notes: From Oracle8i release 8.1.6 one can send e-mail
messages
> > > rem directly from PL/SQL using either the UTL_TCP or UTL_SMTP
> > > rem packages. No pipes or external procedures required.
> > > rem Date: 27-Mar-2000
> > > rem Author: Frank Naude (frank_at_ibi.co.za)
> > >
> > rem
> > -----------------------------------------------------------------------
> > >
> > > CREATE OR REPLACE PROCEDURE SEND_MAIL (
> > > msg_from varchar2 := 'oracle',
> > > msg_to varchar2,
> > > msg_subject varchar2 := 'E-Mail message from your database',
> > > msg_text varchar2 := '' )
> > > IS
> > > c utl_tcp.connection;
> > > rc integer;
> > > BEGIN
> > > c := utl_tcp.open_connection('192.168.1.1', 25); -- open the
> > SMTP
> > > port 25 on local machine
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > rc := utl_tcp.write_line(c, 'HELO 192.168.1.1');
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > rc := utl_tcp.write_line(c, 'MAIL FROM: '||msg_from);
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > rc := utl_tcp.write_line(c, 'RCPT TO: '||msg_to);
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > rc := utl_tcp.write_line(c, 'DATA'); -- Start
message
> > > body
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > rc := utl_tcp.write_line(c, 'Subject: '||msg_subject);
> > > rc := utl_tcp.write_line(c, '');
> > > rc := utl_tcp.write_line(c, msg_text);
> > > rc := utl_tcp.write_line(c, '.'); -- End of
message
> > > body
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > rc := utl_tcp.write_line(c, 'QUIT');
> > > dbms_output.put_line(utl_tcp.get_line(c, TRUE));
> > > utl_tcp.close_connection(c); -- Close the
> > > connection
> > > EXCEPTION
> > > when others then
> > > raise_application_error(-20000,'Unable to send e-mail message
> > from
> > > pl/sql');
> > > END;
> > > /
> > > show errors
> > >
> > > -- Examples:
> > > set serveroutput on
> > >
> > > exec send_mail(msg_to =>'Omar Khalid/IT/LotusCert/Pk');
> > > exec send_mail(msg_to =>'omar_khalid_at_mathtechonline.com');
> > >
> > > exec send_mail(msg_to =>'omar_khalid_at_mathtechonline.com',
> > > msg_text=>'Look Ma I can send mail from plsql');
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> > > Oracle DBA
> > > <acur8dba_at_yaho To: Multiple recipients
of
> > list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > o.com> cc:
> > > Sent by: Subject: How to send
email
> > from pl/sql in 806?
> > > root_at_fatcity.c
> > > om
> > >
> > >
> > > 05/23/2001
> > > 11:35 AM
> > > Please respond
> > > to ORACLE-L
> > >
> > >
> > >
> > >
> > >
> > > Hi,
> > >
> > > I am aware that 817 supports UTL_SMTP for this same
> > > functionality. But how can one send email from pl/sql
> > > in 806?
> > >
> > >
> > > thanx
> > >
> > > =====
> > > Vicky D. Foster,
> > > Senior Oracle DBA:
> > > email: acur8dba_at_yahoo.com
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Auctions - buy the things you want at great prices
> > > http://auctions.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Oracle DBA
> > > INET: acur8dba_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: OKhalid_at_lmkr.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Saurabh Sharma
> > INET: saurabhs_at_fcsltd.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Venkata Ramana Kanchinadam
> INET: vkanchinadam_at_sierraopt.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Saurabh Sharma
  INET: saurabhs_at_fcsltd.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).