Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Executing sqlj/java objects in oracle

 
priya kalyan
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic