Re: Java Stored Procedures

The script %ORACLE_HOME%\javavm\install\initjvm.sql needs to be run as SYS. Be aware that this is a large installation (certainly on NT) and I had
to:
 triple my swap file size
 add 30Mbyes to my shared_pool_size
 introduce the init.ora parameter java_pool_size at about 30Mbytes  ensure you have lots of rollback segment

Cheers,

Fred J

Christopher Hurley <cphurley_at_alumni.princeton.edu> wrote in message news:3a145b35$1_at_news....
> Oracle 8.1.5 on Win 2000 Professional
>
> I have been looking into using java stored procedures. I am trying to
> execute the sample in Oracle Documentation. I created some tables, then I
> wrote the java source code, compiled it into a class, and then tried to
 run
> loadjava on the class file. When I do not use the resolve flag, the class
> is inserted into the database, but when I DO use the resolve flag I get
 the
> following error:
> ORA-00904: invalid column name
>
> When I run loadjava in debug mode, I see that the error occurs in the
> following line:
> select dbms_java.shortname('JavaClassName') from dual;
>
> I believe the problem is that I do not have a package called dbms_java
> anywhere in my database. I have a package called dbms_java_test, but
> nothing named just dbms_java. So, I am getting the error when trying to
> select from the procedure 'shortname'. I am not really sure why loadjava
 is
> calling the 'shortname' procedure anyway, does anyone have info on this?
>
> Has anybody run into similar problems? Does anyone with Oracle 8.1.5 have
> the dbms_java package? Any assistance is greatly appreciated.
>
> Chris
>
>
>
Received on Fri Nov 17 2000 - 03:02:19 CST