UTL_MAIL package configure/install

[daljitsb]

Environment: Oracle 10g (10.1.0.2.0) standard edition on Windows 2003 server

I need to install utl_mail package and this is the link I am working with http://download-east.oracle.com/docs...802/u_mail.htm

The link above asks says:

------------------------
Operational Notes
You must both install UTL_MAIL and define the SMTP_OUT_SERVER.

To install UTL_MAIL:
sqlplus sys/
SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.sql


You define the SMTP_OUT_SERVER parameter in the init.ora rdbms initialization file. However, if SMTP_OUT_SERVER is not defined, this invokes a default of DB_DOMAIN which is guaranteed to be defined to perform appropriately.
--------------------------

I successfully ran and installed utlmail.sql, but the issue is I don't see prvtmail.sql file exist but only prvtmail.plb. So how do I run SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.sql
to install SMTP_OUT_SERVER.

Please help.

-D

[davey23uk]

run the plb file

[Thomasps]

I think you can run the file directly..

SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb

Could be a document error!

[daljitsb]

Thanks. Direc t running @$ORACLE_HOME/rdbms/admin/prvtmail.plb
works.

-D

[daljitsb]

I am still unable to send emails using the package

Earlier the error on using

begin
-- Call the procedure
utl_mail.send('user@company.com','user@company.com');
end;

was
---------
error Message: ORA-20001: Failed to send mail due to the following error: ORA-29261: bad argument
ORA-20001: Failed to send mail due to the following error: ORA-29261: bad argument
---------

now after I have inistalized the parameter

smtp_out_server = ww01.int.a.com:25, b.int.a.com:25, ww02.int.a.com:25 SCOPE=both;

the message I am getting is
--------
Failed to send mail due to the following error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-20001: Failed to send mail due to the following error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
--------

Send procedure takes following parameters out of which only the first 2 are required - precipients & pcc

procedure send(precipients varchar2,
pcc varchar2,
pbcc varchar2,
psubject varchar2,
pmessage varchar2,
pmime_type varchar2, -- Default 'text/plain;
ppriority pls_integer, -- Default NULL
pexc boolean);

I could not find any help on web. Please help.

-D