I am trying to send email from a procedure. I am using UTL_SMTP package. But when I am doing UTL_SMTP.OPEN_CONNECTION('MY MAIL HOST', 25)
I am getting an error as follows.
ORA-29540: class oracle/plsql/net/TCPConnection does not exist
ORA-06512: at "SYS.UTL_TCP", line 533
ORA-06512: at "SYS.UTL_TCP", line 199
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 121
Could anyone guide me how to go about this problem.
i suppose, you could have already run initjvm.sql as sys.
eventhough, run another script available at initplsj.sql
as sys and try again.