I loaded a java class in oracle with a method as below:
public static String execute( Vector p_vec,boolean isManagerger,String p_managerID ){
///
}
I loaded this class in oracle.Now I want to created a wrapper oracle function/procedure in oracle.
I tried as below,but it is not accepting java.util.Vector in PARSEDATA.I also tried putting VARRAY in the place of java.util.Vector , and it says VARRAY must be declared.
PACKAGE BANK AUTHID CURRENT_USER AS
PROCEDURE PARSEDATA ( "vec" IN java.util.Vector , "isManager" IN boolean , "managerId" IN varchar2 , "result" OUT varchar2)
AS LANGUAGE JAVA NAME
'ManagerParser.execute(java.util.Vector,boolean,java.lang.String)';
END Bank;
My doubt is
1)( in java class to be loaded in Oracle) can we have a Vector param in method.
If we can have it,what is the oracle equivalent param ,we should give in Vector's place.
If we can't ,what is the work around.
2)How do we specify the return type in procedure
Pl give your suggestions.If you can give a sample snippet that will be great !!
Thank you very much.
