PL/SQL function executing java class problem.

963306

Hello, i`m having a problems with executing java class in pl/sql function. I`m trying to call a simple function like this:
create or replace function callme(alfa in NUMBER)
return NUMBER
AS LANGUAGE JAVA
NAME 'start.fun(java.lang.Integer) return java.lang.Integer';
/

a java class is looking like:
import java.io.*;
import java.util.*;
public class start {
public static int fun(int alfa)
{
return alfa + 10;
}
}

everything is compiled without error. When i`m trying to call:
select callme(10) from dual; im getting error ORA-29531 missing method fun.
Can some1 help me? It is problem with mapping ??

Johnreardon

Hi this is the Oracle Designer forum. You would be better off asking this question over at the SQL & PL/SQL place

3077