Home » SQL & PL/SQL » SQL & PL/SQL » error when I send email from a stored procedure
error when I send email from a stored procedure [message #39655] Wed, 31 July 2002 06:46 Go to next message
Raffaele
Messages: 2
Registered: July 2002
Junior Member
Hi,
I tried to send email with stored procedure.
It run correctly just I connect with system/manager.
If I change user/password don't run my procedure and I see this error:

ERROR at line 1:
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
ORA-06512: at "AFM.SPEDISCI_MAIL", line 17
ORA-06512: at line 1

is normal???

i run these scripts (as internal/oracle - sys/change_on_install - myuser/password):

@c:oracleora81rdbmsadmininitplsj.sql
@c:oracleora81j avavminstallinitjvm.sql
@c:oracleora81javavminstallinit_security.sql

thanks!!!
Raffaele
Re: error when I send email from a stored procedure [message #39656 is a reply to message #39655] Wed, 31 July 2002 06:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try again after running the script initplsj.sql as SYS available in $ORACLE_HOME/rdbms/admin
Previous Topic: use value of one variable as a name of the second variable
Next Topic: Creating a temp table and unique numbering
Goto Forum:
  


Current Time: Thu Mar 28 19:03:15 CDT 2024