SQLJ-Generated Code Loaded into 10.2.0.4 DB Fails with 'Closed Statement' when Being Called.
(Doc ID 758194.1)
Last updated on MARCH 20, 2019
Applies to:SQLJ - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
When loading .class files generated by 10.2.x.x SQLJ into a 10.2.0.2 or 10.2.0.3 database and creating Java Stored Procedures to call these class files, calls to these Java Stored Procedures from an anonymous PL/SQL block are successful. However, when performing the same operation, but loading the .class files to a 10.2.0.4 database, the call to the Java Stored Procedure fails from an anonymous PL/SQL block fails with the following error:
ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: Closed
These .class files were generated using 10.2.x.x SQLJ (through version 10.2.0.4) with JDK 1.4.2. Either version of SQLJ worked against a 10.2.0.2 or 10.2.0.3 database but failed against 10.2.0.4. The same error is seen when using JDK 1.5 and loading the .class files to an 126.96.36.199 database.
The error can be seen by running following testcase:
- Create and populate test table from SQL*Plus:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document