Re: simple java stored function doesn't work

kostakis wrote:
> Hello,
>
> I try to create very simple java function in my oracle 9i. The java
> source is:
>
> CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "Klasa" AS
> public class Klasa {
> public static int getInt(int in_in) {
> return(in_in);
> }
> };
> /
> This soruce compiles without any errors. I created also function:
>
> CREATE OR REPLACE function klasa_getint return number as language java
> name 'Klasa.getInt(int) return int';
> /
> which compiles without errors also.
>
> But when i invoke:
> select klasa_getint(5) from dual
> i become error:
> ORA-06553: PLS-306: wrong number or types of arguments in call to
> 'KLASA_GETINT'
>
> Why is that?

Read the error carefully and you will get your answer.

• How many arguments do you have for Klasa.getint java function?
• How many IN arguments have you specified for klasa_getint wrapper function?

Regards
/Rauf Received on Fri May 26 2006 - 07:43:49 CDT