e- Mail Problem [message #72684] |
Tue, 02 September 2003 22:28 |
Patel Dhiren
Messages: 8 Registered: April 2003
|
Junior Member |
|
|
APPS:CLON>exec send_mail(msg_to=>'dhiren30p@yahoo.co.in', -
> msg_subject => 'Hello from Oracle', -
> msg_text => 'This is the body of the message'-
> );
BEGIN send_mail(msg_to=>'dhiren30p@yahoo.co.in', msg_subject => 'Hello from Oracle', msg_text => '
*
ERROR at line 1:
ORA-29531: no method get_crlf in class oracle/plsql/net/TCPConnection
ORA-06512: at "SYS.UTL_TCP", line 678
ORA-06512: at "SYS.UTL_TCP", line 671
ORA-06512: at "SYS.UTL_SMTP", line 102
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "APPS.SEND_MAIL", line 11
ORA-06512: at line 1
|
|
|
Re: e- Mail Problem [message #72689 is a reply to message #72684] |
Mon, 15 September 2003 17:41 |
Frank Naude
Messages: 4587 Registered: April 1998
|
Senior Member |
|
|
Hi,
See Metalink Note 160798.1
This can be fixed with -
1. connect as SYS
2. run $ORACLE_HOME/rdbms/admin/initplsj.sql
Best regards.
Frank
|
|
|