smtp mail set up

[Shumi Begum]

our oracle developer writing procedure and wants to send mail using UTL_SMTP.
It gives error such as map domaintable is not found.
Do i need to setup smtp mail on UNIX? If so how? We are using HP L1000 server with OS 11.0
Thanks for your help.
shumi

[Michael Elleby III_1]

Hello-

A question, where is the mail originating? From a client, or on the server where Oracle exists? And what type of user is this mail going to?

I've never heard of UTL_SMTP, but basically, to configure a UNIX server to send mail, you first need the name of an smtp host that you normally get from your Mail (or Exchange) administrator. This gets encoded in the sendmail.cf file on the line indicated by "DS". Once you do this and restart the sendmail service on your server, you can issue mail commands to accounts on the server, and sendmail will take care of forwarding the mail to the smtp host if the receiver is external.

HTH-

Mike