Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How to use dbms_java.loadjava
Amy
post Nov 30 2006, 09:55 AM
Post #1


Newbie
*

Group: Members
Posts: 6
Joined: 29-November 06
Member No.: 5,890



Hello,

I'm relatively new to Oracle, and right now I've been asked to figure out how to load Java stored procedures into Oracle. I have used the "CREATE JAVA SOURCE" command just fine, and looking in the all_objects table I see the new object exists. But I'm trying to use the loadjava utility without success. I have made and compiled a test java class called "Hello.class".

The problem is now I cannot load the class into Oracle. I have tried to use the following:

SQL> exec dbms_java.loadjava('-a -v -s -g public "e:\java\bin\hello.class"');

The file is on my "e:" drive in the java\bin directory. This is NOT where Oracle is being run from. Oracle is being run on another server on the LAN. When I run the command I get the response:
"PL/SQL procedure successfully completed."
but checking the all_objects table shows nothing new has been added.

This is probably easy, but what am I doing wrong? Thanks,
Amy
Go to the top of the page
 
+Quote Post
dave
post Nov 30 2006, 10:41 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



user the loadjava command line utility
Go to the top of the page
 
+Quote Post
Amy
post Nov 30 2006, 12:08 PM
Post #3


Newbie
*

Group: Members
Posts: 6
Joined: 29-November 06
Member No.: 5,890



QUOTE (dave @ Nov 30 2006, 03:42 PM) *
user the loadjava command line utility

Thanks..
When I try with loadjava command utility,I get theis message : 'loadjava' is not recognized as an internal or external command, I think Is it on my path, but I don't know how to setup and use loadjava in windows xp.

Please do help. Thankyou for your time.
Amy
Go to the top of the page
 
+Quote Post
dave
post Nov 30 2006, 12:19 PM
Post #4


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



what doyou have installed on your PC, do you have the oracle client, if so what version
Go to the top of the page
 
+Quote Post
Amy
post Nov 30 2006, 01:02 PM
Post #5


Newbie
*

Group: Members
Posts: 6
Joined: 29-November 06
Member No.: 5,890



QUOTE (dave @ Nov 30 2006, 05:20 PM) *
what doyou have installed on your PC, do you have the oracle client, if so what version



I do not have installed in my PC oracle client , I access to oracle database from a unit of network. In the server it is installed Oracle9i Release 9.0.1.4.0
Go to the top of the page
 
+Quote Post
dave
post Nov 30 2006, 06:50 PM
Post #6


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



well you need an oracle client to load java files which are not on the database server
Go to the top of the page
 
+Quote Post
Amy
post Dec 1 2006, 01:21 PM
Post #7


Newbie
*

Group: Members
Posts: 6
Joined: 29-November 06
Member No.: 5,890



QUOTE (dave @ Nov 30 2006, 11:51 PM) *
well you need an oracle client to load java files which are not on the database server

Ok, thanks a lot for your help.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st October 2014 - 07:12 AM