| Utl Mail [message #342396] |
Fri, 22 August 2008 04:31  |
madhavangk
Messages: 4
Registered: August 2008
Location: Chennai
|
Junior Member |
|
|
Hai Friends
My program is
DECLARE
CRLF CHAR(2) := CHR(10) || CHR(13);
BEGIN
-- Send a simple e-mail message from within the database
utl_mail.send(
sender => 'madhavan@vaarida.com'
,recipients => 'info@vaarida.com'
,cc => 'lakshminarayanan@vaarida.com'
,bcc => NULL
,subject => 'When is LongHorn due out? Really??'
,message => 'Dear Mr. Gates: ' || CRLF || CRLF
|| 'I would really love to play with LongHorn soon!' || CRLF || CRLF
|| 'Kind regards,' || CRLF || CRLF
|| 'Jim Czuprynski'
,mime_type => 'text/plain; charset=us-ascii'
,priority => 1
);
end;
in this im getting some errors. the errors is
ERROR at line 1:
ORA-29261: bad argument
ORA-06512: at "SYS.UTL_TCP", line 28
ORA-06512: at "SYS.UTL_TCP", line 257
ORA-06512: at "SYS.UTL_SMTP", line 116
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "SYS.UTL_MAIL", line 405
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 7
anybody can solve the problem
please
|
|
|
|
| UTL_MAIL [message #342397 is a reply to message #342396] |
Fri, 22 August 2008 04:32  |
madhavangk
Messages: 4
Registered: August 2008
Location: Chennai
|
Junior Member |
|
|
Hai Friends
My program is
DECLARE
CRLF CHAR(2) := CHR(10) || CHR(13);
BEGIN
-- Send a simple e-mail message from within the database
utl_mail.send(
sender => 'madhavan@vaarida.com'
,recipients => 'info@vaarida.com'
,cc => 'lakshminarayanan@vaarida.com'
,bcc => NULL
,subject => 'When is LongHorn due out? Really??'
,message => 'Dear Mr. Gates: ' || CRLF || CRLF
|| 'I would really love to play with LongHorn soon!' || CRLF || CRLF
|| 'Kind regards,' || CRLF || CRLF
|| 'Jim Czuprynski'
,mime_type => 'text/plain; charset=us-ascii'
,priority => 1
);
end;
in this im getting some errors. the errors is
ERROR at line 1:
ORA-29261: bad argument
ORA-06512: at "SYS.UTL_TCP", line 28
ORA-06512: at "SYS.UTL_TCP", line 257
ORA-06512: at "SYS.UTL_SMTP", line 116
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "SYS.UTL_MAIL", line 405
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 7
anybody can solve the problem
please
|
|
|
|
| UTL_MAIL [message #342398 is a reply to message #342396] |
Fri, 22 August 2008 04:34 |
madhavangk
Messages: 4
Registered: August 2008
Location: Chennai
|
Junior Member |
|
|
Hai Friends
My program is
DECLARE
CRLF CHAR(2) := CHR(10) || CHR(13);
BEGIN
-- Send a simple e-mail message from within the database
utl_mail.send(
sender => 'madhavan@vaarida.com'
,recipients => 'info@vaarida.com'
,cc => 'lakshminarayanan@vaarida.com'
,bcc => NULL
,subject => 'When is LongHorn due out? Really??'
,message => 'Dear Mr. Gates: ' || CRLF || CRLF
|| 'I would really love to play with LongHorn soon!' || CRLF || CRLF
|| 'Kind regards,' || CRLF || CRLF
|| 'Jim Czuprynski'
,mime_type => 'text/plain; charset=us-ascii'
,priority => 1
);
end;
in this im getting some errors. the errors is
ERROR at line 1:
ORA-29261: bad argument
ORA-06512: at "SYS.UTL_TCP", line 28
ORA-06512: at "SYS.UTL_TCP", line 257
ORA-06512: at "SYS.UTL_SMTP", line 116
ORA-06512: at "SYS.UTL_SMTP", line 139
ORA-06512: at "SYS.UTL_MAIL", line 405
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 7
anybody can solve the problem
please
|
|
|
|
|
|
| Re: Utl Mail [message #342405 is a reply to message #342396] |
Fri, 22 August 2008 04:54 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
1/ Read OraFAQ Forum Guide
2/ Don't multipost
3/ Read "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
4/ Always post your Oracle version (4 decimals).
5/ Search error meaning
ORA-29261: bad argument
*Cause: A bad argument was passed to the PL/SQL API.
*Action: Check the arguments passed to the PL/SQL API and retry the call.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
