Sunday, June 17, 2012

Oracle calling Java Resources


We can load various resources like jar,zip,text,imges using loadjava utility
 

loadjava -user userid/password HelloWorld.class
 

SELECT object_name, object_type, status
       FROM user_objects
       WHERE object_name LIKE '%Hello%';


create or replace function HELLO return VARCHAR2 as language java name 'Hello.world () return java.lang.String';

variable myString varchar2(20);
call HELLO2 into :myString;
 

select HELLO from dual;

No comments:

Post a Comment