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:
Enregistrer un commentaire