Home » SQL & PL/SQL » SQL & PL/SQL » Utl Mail
Utl Mail [message #342396] Fri, 22 August 2008 04:31 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #342403 is a reply to message #342398] Fri, 22 August 2008 04:53 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Please don't multi-post.
Re: Utl Mail [message #342405 is a reply to message #342396] Fri, 22 August 2008 04:54 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Dynamic Sql
Next Topic: File Line Count
Goto Forum:
  


Current Time: Fri Dec 02 14:29:44 CST 2016

Total time taken to generate the page: 0.21148 seconds