OraFAQ Forum: Server Administration » pl/sql package using UTL

Home » RDBMS Server » Server Administration » pl/sql package using UTL_FILE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pl/sql package using UTL_FILE [message #241787]

Wed, 30 May 2007 11:08

asadaslam18
Messages: 16
Registered: May 2007
Location: nine

Junior Member

How can we send email through pl/sql package using UTL_FILE
in oracle9i?

Report message to a moderator

Re: pl/sql package using UTL_FILE [message #241789 is a reply to message #241787]

Wed, 30 May 2007 11:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You do NOT.
You should use UTL_SMTP & you can learn how to do so by Reading The Fine Manual found at http://tahiti.oracle.com where this package is documented.

Report message to a moderator

Re: pl/sql package using UTL_FILE [message #241790 is a reply to message #241789]

Wed, 30 May 2007 11:24

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

There are plenty of "sending mail" scripts at http://www.orafaq.com/scripts/

Report message to a moderator

Re: pl/sql package using UTL_FILE [message #241821 is a reply to message #241790]

Wed, 30 May 2007 12:12

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

you can send mails and attachements through

UTL_MAIL package.

http://builder.com.com/5100-6388_14-6078020.html

Report message to a moderator

Re: pl/sql package using UTL_FILE [message #241828 is a reply to message #241787]

Wed, 30 May 2007 12:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

DreamzZ,
Please RTFQ.
OP clearly states 9i & UTL_MAIL did not exist until V10

Report message to a moderator

Re: pl/sql package using UTL_FILE [message #241831 is a reply to message #241828]

Wed, 30 May 2007 12:27

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Ops.
Thanks

Report message to a moderator

Previous Topic:	doubt in database
Next Topic:	CPU patch

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 02:04:21 CDT 2024