1 Reply Latest reply: Jun 26, 2014 8:30 AM by Marwim RSS

    Java Procedure in Database

    Muhammad Rabie

      create or replace AND RESOLVE java class using bfile(temp,'jic.class');

       

      SELECT object_name

      , object_type

      , status

      FROM user_objects

      where object_type like 'JAVA%';

       

      OUTPUT

      jic    JAVA CLASS    VALID

       

      CREATE or replace FUNCTION cap(a number,b number, c number,d number) RETURN VARCHAR2 AS

      LANGUAGE JAVA

      NAME 'jic.image_cap(int,int,int,int) return java.lang.String';

       

      SELECT CAP(101,101,10,10) FROM DUAL;

       

       

      ORA-29532: Java call terminated by uncaught Java exception: java.lang.NoClassDefFoundError

      29532. 00000 -  "Java call terminated by uncaught Java exception: %s"

      *Cause:    A Java exception or error was signaled and could not be

                 resolved by the Java code.

      *Action:   Modify Java code, if this behavior is not intended.