| 
		
			| LOADJAVA [message #130460] | Sun, 31 July 2005 00:00  |  
			| 
				
				
					| kentvickery Messages: 3
 Registered: July 2005
 | Junior Member |  |  |  
	| I am just starting to get into loading java into my database so I can call it from PL/SQL.  My question is, can a function/procedure in a java class that has been loaded into my database with LOADJAVA make calls to an external .JAR, or do I have to have everything loaded into the database. 
 Right now I am able to compile a class file that references a .JAR library, but when I try to load the class into the database using LOADJAVA I get an error saying the referenced name (the JAR package name) cannot be found.  The JAR is a custom package that in turn references things like LOG4J.
 
 I don't want to have to load JAR files into the database if I don't have to.  I am running Oracle 9i.  I've tried setting my CLASSPATH to point to where the JAR is, but no luck.  Am I missing something.
 
 loadjava -user user/pwd -oci8 -resolve Tester.class
 
 Thanks
 |  
	|  |  | 
	|  | 
	|  |