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

Saurabh Sharma wrote:
>
> 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.

Simple.
Its in %ORACLE_BASE%\Ora81\rdbms\admin\  where you're find utltcp.sql and utlsmtp.sql, and lots of other goodies.
It would not be included with an Oracle 8.0.x distribution. 8.1.6 goes off support 31-OCT-2001 - go straight to 8.1.7.1.x.

Paul

> ----- 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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).