-
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:\oracle\ora81\rdbms\admin\initplsj.sql
@c:\oracle\ora81\j avavm\install\initjvm.sql
@c:\oracle\ora81\javavm\install\init_security.sql
thanks!!!
Raffaele
-
Login as SYS or SYSTEM and grant the user JAVASYSPRIV and JAVAUSERPRIV roles and execute the procedure again. This should work.
Good luck,
Ravi Indurti
-
Originally posted by rindurti
Login as SYS or SYSTEM and grant the user JAVASYSPRIV and JAVAUSERPRIV roles and execute the procedure again. This should work.
Good luck,
Ravi Indurti
hi,
how can I write??
connect system/manager (or internal/oracle)
after I wrote:
grant JAVASYSPRIV TO my_user;
but don't run: ERROR at line 1:
ORA-01917: user or role 'my_user' does not exist
I must create this role??
How Can I do???
thanks!!
bye
Raffaele
-
Stop and think a bit first ...
Are you sure that your JVM installation went OK? Do you have enought JAVA_POOL_SPACE to execute the Java code? It would seem you do, since you were able to send e-mail from the SYSTEM login, but be sure your JVM is working OK. You might want to check METALINK out for more help, too.
-
Originally posted by raf
Hi,
i run these scripts (as internal/oracle - sys/change_on_install - myuser/password):
@c:\oracle\ora81\rdbms\admin\initplsj.sql
@c:\oracle\ora81\j avavm\install\initjvm.sql
@c:\oracle\ora81\javavm\install\init_security.sql
Raffaele: Did you execute these scripts three times (once for each id)?
If this is the case, the you have to de-install (drop, remove) all objects that were created by these scripts in your 'myuser' schema! This may be the cause of the error.
BTW, re-connecting as 'system' inside a procedure is not the solution.
MikeOM>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|