This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Executing sqlj/java objects in oracle" Watch "Executing sqlj/java objects in oracle" New topic

Executing sqlj/java objects in oracle

priya kalyan

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 '' as java.lang.String'
myString varchar2(20);
call HELLOWORLD() :myString;
print myString;
I cud not execute it
Cud anyone solve my problem
I agree. Here's the link:
subject: Executing sqlj/java objects in oracle
It's not a secret anymore!