1>public class Generator{
public class Generator(){}
public String[] Generate(int length,int bundle){}
}2>loadjava -v -u mcc/mcc@oradblinux Generator.class3>CREATE FUNCTION generator_generate(leng number,bundle number) RETURN VARCHAR2[]---Error 数组标示有误
AS LANGUAGE JAVA
NAME 'Generator.Generate(int,int) return java.lang.String[]';4〉在线等待
public class Generator(){}
public String[] Generate(int length,int bundle){}
}2>loadjava -v -u mcc/mcc@oradblinux Generator.class3>CREATE FUNCTION generator_generate(leng number,bundle number) RETURN VARCHAR2[]---Error 数组标示有误
AS LANGUAGE JAVA
NAME 'Generator.Generate(int,int) return java.lang.String[]';4〉在线等待
CREATE OR REPLACE PACKAGE pkg_test
AS
TYPE myrctype IS REF CURSOR;
END pkg_test;
/create procedure pro(c out pkg_test.myrctype)
as
str varchar2(200);
begin
str:='select * from table.....'
open c for str;
end;
/
我本想取得该过程返回String[]数组,
但无法在Oracle 中找到对应的数据类型。
我就重写该过程,
能认识你很高兴
十分感谢