error when I send email from a stored procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: error when I send email from a stored procedure

  1. #1
    Join Date
    Jul 2002
    Posts
    228
    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

  2. #2
    Join Date
    Jul 2002
    Posts
    1
    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

  3. #3
    Join Date
    Jul 2002
    Posts
    228
    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

  4. #4
    Join Date
    Jun 2001
    Location
    Hanover Park, IL
    Posts
    3

    Question 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.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,477
    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
  •  



Click Here to Expand Forum to Full Width