|
-
I am still unable to send emails using the package
Earlier the error on using
begin
-- Call the procedure
utl_mail.send('[email protected]','[email protected]');
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
|