Forum Stats

  • 3,750,349 Users
  • 2,250,160 Discussions
  • 7,866,946 Comments

Discussions

PL/SQL function executing java class problem.

963306
963306 Member Posts: 8
edited May 20, 2013 3:51AM in Designer
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 ??
Tagged:

Answers

This discussion has been closed.