wood burning stoves 2.0*
The moose likes JDBC and the fly likes Executing sqlj/java objects in oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Executing sqlj/java objects in oracle" Watch "Executing sqlj/java objects in oracle" New topic
Author

Executing sqlj/java objects in oracle

priya kalyan
Greenhorn

Joined: Dec 19, 2000
Posts: 5
Hi all,

I have encountered with a problem while executing java objects in oracle
public class Hello
{
public static String world ()
{
return "Hello world";
}
}
By this prog a Hello class is created
and the same is loaded to oracle by
load java -user scott/tiger@hoststring Hello.class
When i try to call this class file in oracle using the func
create or replace function HELLOWORLD return varchar as
language java name 'Hello.world' as java.lang.String'
myString varchar2(20);
call HELLOWORLD() :myString;
print myString;
I cud not execute it
Cud anyone solve my problem
Priya
 
 
subject: Executing sqlj/java objects in oracle
 
Similar Threads
Connecting to local Web Service from Android emulator does not work
JNI Program RunTime Exceptions
Number of String objects
Oracle JDBC loadjava stored proc problem
Inheritance - Object Class