Oracle Java procedure 中使用 out 參數

今天同事有個Java procedure,需要傳出參數. 無法解決.
在oracle網站找到了方法

Setting Parameter Modes

In Java and other object-oriented languages, a method cannot assign values to objects passed as arguments. When calling a method from SQL or PL/SQL, to change the value of an argument, you must declare it as an OUT or IN OUT parameter in the call specification. The corresponding Java parameter must be an array with only one element.

You can replace the element value with another Java object of the appropriate type, or you can modify the value if the Java type permits. Either way, the new value propagates back to the caller. For example, you map a call specification OUT parameter of the NUMBER type to a Java parameter declared as float[] p, and then assign a new value to p[0].

Note:

A function that declares OUT or IN OUT parameters cannot be called from SQL data manipulation language (DML) statements.

做了個小範例測試
傳入varchar2, 用out參數返回字串長度

create or replace java source named "Hello" as
        public class Hello {
                static public void Message(String name, int ret[]) {
                        ret[0] = name.length() ;
        }
}
/

create or replace procedure hello (name VARCHAR2, aa out number ) as language java name 'Hello.Message (java.lang.String, int[]) ';
/

var r number ;
call hello('world', :r) ;

print :r ;


                                阿飛
                     2007/12/03