Originally posted by SAJI
I Configured oracle 8.1.6 for SMPT.
When i try to send mail , this is the error i am getting.
can anyone help me
Run %ORACLE_HOME/javavm/plsql/jlib/initjvm.sql
Run %ORACLE_HOME/rdbms/java/install/initplsj.sql
the above 2 file i fired using @d:\.....\ \ .
both the files executed succesfully.



ERROR at line 1:
ORA-20001: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 83
ORA-06512: at "SYS.UTL_SMTP", line 121
ORA-06512: at "SYS.SEND_MAIL", line 12
ORA-06512: at line 1
Did you run loadjava -force -verbose -user sys/password@db %ORACLE_HOME/plsql/jlib/plsql.jar between initjvm.sql and initplsj.sql. If not, that is why. You will have to reinstall JVM.