UTL_SMTP x INITJVM.SQL

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jorge Pinto

    UTL_SMTP x INITJVM.SQL

    Hi folks,

    I'm having a problem with initjvm.sql. I created a procedure to send a
    message using utl_smtp and when I run it, I got an error ORA-29540. I read
    that I needed to install JVM so I tried. The problem was that I got so many
    errors related with shared pool, declaration variables.

    Is there any configuration or change that I need to do in the init<sid>.ora
    ?? Any idea about what happened..... I tried also to use loadjava but I got
    the same errors.



    Thanks in advance,



    Jorge Pinto




  • Anna C. Dent

    #2
    Re: UTL_SMTP x INITJVM.SQL

    Jorge Pinto wrote:
    Hi folks,
    >
    I'm having a problem with initjvm.sql. I created a procedure to send a
    message using utl_smtp and when I run it, I got an error ORA-29540. I read
    that I needed to install JVM so I tried. The problem was that I got so many
    errors related with shared pool, declaration variables.
    >
    Is there any configuration or change that I need to do in the init<sid>.ora
    ?? Any idea about what happened..... I tried also to use loadjava but I got
    the same errors.
    >
    >
    >
    Thanks in advance,
    >
    >
    >
    Jorge Pinto
    >
    >
    >
    >
    MetaLink in your Friend.
    When all else fails, RTFM.

    Comment

    Working...