DanBrother的部落格

####################
# for Send Mail program
####################
Problem: ORA-29540: class oracle/plsql/net/TCPConnection does not exist

  /**************************/
 /* Complete Solution   */
/*************************/

-COMPATIBLE (init.ora)
compatible = 8.1.7
java_pool_size = 20000K   # make sure it has been set to a large size

-- Set CLASSPTH
export $CLASSPATH=$ORACLE_HOME/jdbc/lib/classes111.zip

-- Remove JVM
run $ORACLE_HOME/javavm/install/rmjvm.sql as sys

-- Re-install JVM
run $ORACLE_HOME/javavm/install/initjvm.sql as sys

-- Load Jar file
loadjava -f -v -r -user sys/password $ORACLE_HOME/plsql/jlib/plsql.jar