2006-04-26

ORA-29531: no method get_crlf in class oracle/plsql/net/TCPConnection

When trying to send a mail with the oracle provided package UTL_SMTP you can get the error ORA-29531: no method get_crlf in class oracle/plsql/net/TCPConnection:

  • Error: 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 99
  • ORA-06512: at "SYS.UTL_SMTP", line 121
  • ORA-06512: at "S716.S724_PA_UTIL", line 2470
  • ORA-06512: at line 2


Metalink Note 160798.1 says:

UTL_SMTP Fails with 'ORA-29531 no Method get_crlf' After Applying Patchset 8.1.7.2 or Above

  • fact: Oracle Server - Enterprise Edition 8.1.7
  • symptom: Error when using UTL_SMTP
  • symptom: ORA-29531: no method get_crlf in class oracle/plsql/net/TCPConnection
  • symptom: ORA-6512: at "SYS.UTL_TCP"
  • symptom: ORA-6512: at "SYS.UTL_SMTP"
  • change: patchset 8.1.7.2 or above applied
  • cause: The steps in the patchset readme for 8172+ does not include re-running initplsj or manually loading this jar.
  • Original problem is caused by Bug 1721293 UTL_SMTP FAILS WITH ORA-29531 .

fix:

1. connect as SYS
2. run $ORACLE_HOME/rdbms/admin/initplsj.sql

Results of the script:
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 26 10:15:39 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.4.0 - 64bit Production
SQL> @$ORACLE_HOME/rdbms/admin/initplsj.sql
Call completed.
Call completed.
SQL> exit


And now all is running succesfully :-)


Aucun commentaire: