知道BUG:1721293 ,如何确认patch号啊.

lflyingfox

知道BUG:1721293 ,如何确认patch号啊.
Download the patch for BUG:1721293 and rebuild the plsql.jar with the provided TCPConnection.class file. Once you have rebuilt the plsql.jar file, you will need to reload it into the database. The UNIX instructions are provided in the patch. The Windows instructions are basically the same and included here for completeness. (Refer to U for UNIX, W for Windows, and B for Both.)
1) Create a temporary directory/folder and download the patch into this location. Unzip the patch.
2) Copy the $ORACLE_HOME/plsql/jlib/plsql.jar into this directory/folder: U) From the temp dir created in step one: $> cp $ORACLE_HOME/plsql/jlib/plsql.jar . W) Use Windows Explorer to navigate and copy/paste the file plsql.jar (in OH\plsql\jlib) to the temp folder
3) Extract the classes in plsql.jar using jar utility:
B) From the command prompt with the temp dir as the current dir, issue command: $> jar -xvf plsql.jar This will create an Oracle directory containing all of the classes within it. Note: jar is a Java ARchive utility provided with the JDK. 4) Copy the supplied class file from the patch into the newly created sub- directory/folder: U) $> cp TCPConnection.class oracle/plsql/net W) Use Windows Explorer to navigate and copy/paste the TCPConnection.class file from the temp folder down into the oracle\plsql\net folder This will replace the class already there. 5) Re-archive the classes into a new jar: B) From the command prompt with the temp dir as the current dir, issue command: $> jar -cvf plsql.jar oracle 6) Copy this new plsql.jar file to its original location U) $> cp plsql.jar $ORACLE_HOME/plsql/jlib W) Use Windows Explorer to navigate and copy/paste the plsql.jar file from the temp folder into the OH\plsql\jlib folder. 7) Reload this new plsql.jar file into the database. From the ORACLE_HOME directory, start sqlplus or svrmgrl and login as sys or internal and execute this command: U) SQL> call dbms_java.loadjava('-resolve -force plsql/jlib/plsql.jar'); W) SQL> call dbms_java.loadjava('-resolve -force plsql\jlib\plsql.jar'); Explanation ----------- The problem is that the plsql.jar file, provided in the 8.1.7.1 and 8.1.7.2 patchsets, contains an invalid TCPConnection class. The provided patch for BUG:1721293 contains the correct TCPConnection class and a readme for reloading it on a UNIX server. Although the report might imply this fix is HP specific, it is generic and can be applied to any platform. References

success

转交给版主了。

纵横四海

看上去晕，麻烦楼主编辑一下吧。

我想知道你的问题到底是什么？？？？
把问题说清楚很重要。

lflyingfox

declare
    v_FromAddr   varchar2(50):='ming@oamail.oatriangle.com.cn';
    v_ToAddr   varchar2(50):='ming@oamail.oatriangle.com.cn';
    v_Message   varchar2(200);
    v_MailHost   varchar2(50):='oamail.oatriangle.com.cn';
    v_MailConnection   UTL_SMTP.CONNECTION;
  begin
    v_Message:='From:'   ||   v_FromAddr   ||   CHR(10)   ||
                          'Subject:Hello   From   gym'   ||   CHR(10)   ||
                          'test777';
    v_MailConnection:=UTL_SMTP.OPEN_CONNECTION(v_MailHost);

    UTL_SMTP.HELO(v_MailConnection,v_MailHost);
    UTL_SMTP.MAIL(v_MailConnection,v_FromAddr);
    UTL_SMTP.RCPT(v_MailConnection,v_ToAddr);
    UTL_SMTP.DATA(v_MailConnection,v_Message);
    UTL_SMTP.QUIT(v_MailConnection);
  end;
运行发邮件时,报错如下;
ORA-29531: 没有方法get_crlf在类oracle/plsql/net/TCPConnection中
ORA-06512: 在"SYS.UTL_TCP", line 678
ORA-06512: 在"SYS.UTL_TCP", line 671
ORA-06512: 在"SYS.UTL_SMTP", line 99
ORA-06512: 在"SYS.UTL_SMTP", line 121
ORA-06512: 在line 11
问题就是以上BUG:1721293问题,oracle 数据库需要patch.

lflyingfox

以上是写的 oracle数据库邮件发送程序.