Re: Java Stored Procedures

I ran into a similar problem. After scouring the Docs I found a file I needed to run as sys. something like initjava.sql in the admin dir with catproc.sql et at. That fixed it. If you use the auto db builder I think it adds this automatically. But if you don't it isn't. It takes about 10 minutes to run. It is mentioned in the installation notes about Java. I don't have the manual in front of me.
Jim

"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 Thu Nov 16 2000 - 19:56:38 CST