Home » RDBMS Server » Server Utilities » e- Mail Problem
e- Mail Problem [message #72684] Tue, 02 September 2003 22:28 Go to next message
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 Go to previous message
Frank Naude
Messages: 4580
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
Previous Topic: ORA-12560
Next Topic: Trigger problem
Goto Forum:
  


Current Time: Sun Jun 30 11:38:57 CDT 2024