PL/SQL function executing java class problem.
963306May 20 2013 — edited May 20 2013Hello, 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 ??