-
UTL_MAIL package configure/install
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
-
-
I think you can run the file directly..
SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb
Could be a document error!
-
Thanks. Direc t running @$ORACLE_HOME/rdbms/admin/prvtmail.plb
works.
-D
-
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
Last edited by daljitsb; 08-02-2006 at 11:56 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|