Dear all,
I tried to execute a java code in PL/SQL via SQLplus. What I did before run the code, were:
1. Created and compile the code.
2. Loaded the the class
3. Created PL/SQL function, which is a wrapper to the java function.
All the steps were successfully executed, however when I tried to run the PL/SQL function I got:
SQL> EXEC DBMS_OUTPUT.PUT_LINE (fdelete('/home/oracle/some_file.txt'))
BEGIN DBMS_OUTPUT.PUT_LINE (fdelete('/home/oracle/some_file.txt')); END;
*
ERROR at line 1:
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
Uncaught exception System error: java/lang/UnsupportedClassVersionError
ORA-06512: at "HR.FDELETE", line 1
ORA-06512: at line 1
What is the problem?
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
oracle@firefly]$ java -version
java version "1.6.0_26"
Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)
[oracle@firefly]$ java -jar ojdbc5.jar
Oracle 11.2.0.1.0 JDBC 3.0 compiled with JDK5
[oracle@firefly]$ java -jar ojdbc6.jar
Oracle 11.2.0.1.0 JDBC 4.0 compiled with JDK6
Please help,
best regards,
Val