Oracleµ÷ÓÃJava´úÂë

 OracleÖпÉÒÔµ÷ÓÃJavaµÄ´úÂ룬һ°ãͨ¹ýÁ½ÖÖ·½Ê½½øÐе÷Óã¬Ò»¸öÊÇÖ±½Ó½«Java´úÂëдÔÚOracleÄÚ²¿£¬ÁíÍâÒ»ÖÖÊǽ«±àÒëºÃµÄclassÎļþÔØÈëµ½OracleÖС£
-A-
1¡¢ÔÚSQLPlusÖд´½¨OracleÖеÄJavaÀàÓë·½·¨£¨·½·¨±ØÐëÊǾ²Ì¬¹«Óз½·¨£©
create or replace and compile java source named hello as
public class Hello {
public static String Message(String name) {
return "Hello, " + name;
}
}    
2¡¢´´½¨º¯Êýµ÷ÓÃÔØÈëOracleÖеÄJava·½·¨¡£
 create or replace function hello (name varchar2)
return varchar2
as
language java name 'Hello.Message(java.lang.String) return java.lang.String';
3¡¢Ö´Ðк¯Êý¼´¿É¿´µ½½á¹û......
 select hello('world!') from dual
-B-
1¡¢´´½¨Òªµ÷ÓõÄJava´úÂ룬²¢±àÒë³ÉClassÎļþ¡£±»µ÷Óõķ½·¨ÒÀ¾É±ØÐëΪ¾²Ì¬¹«Óз½·¨
public class Number {
public static int getNumber() {
return 99;
}
}

2¡¢ÓÃloadjavaÃüÁîÔÚ¿ØÖÆ̨ÉϽ«classÎļþ¼ÓÔص½Oracle»·¾³ÖÐ
loadjava -u sys/sys@orcl -oci8 -verbose -grant scott -synonym -resolve -schema scott D:\Number.class
Èç¹ûÏëҪжÔØÒѾ­¼ÓÔصÄclassµÄ»°£¬Ê¹ÓÃdropjavaÃüÁî
 dropjava -user sys/sys@orcl Number
Èç¹ûÌáʾÈçÏÂÐÅÏ¢£¬±íʾ¼ÓÔسɹ¦£¨£©
 arguments: '-u' 'sys/sys@orcl' '-oci8' '-verbose' '-grant' 'scott' '-synonym' '-resolve' '-schema' 'scott' 'D:\Number.class'
identical: Number
granting : execute on class SCOTT.Number to scott
skipping : class SCOTT.Number
synonym : SCOTT.Number
Classes Loaded: 1
Resources Loaded: 0
Sources Loaded: 0
Published Interfaces: 0
Classes generated: 0
Classes skipped: 0
Synonyms Created: 1
Errors: 0
3¡¢´´½¨µ÷Ó÷½·¨µÄ·½Ê½Í¬A·½Ê½µÄµÚ2²½
4¡¢µ÷Ó÷½·¨µÄ·½Ê½Í¬A·½Ê½µÄµÚ3²½