1 Reply Latest reply: May 20, 2013 2:51 AM by Johnreardon RSS

    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 ??