Dear All,
I'm facing the migration of the database from Oracle 12.2 to Oracle 19, and I'm testing my desktop application using the Oracle Client 12.2.0.1. Everything works fine but... the call to the LOADJAVA application used to import Java classes into the database.
When the application attempts the call using a command like this
loadjava -user MYUSER/MYPWD@MYTNS-resolve -force -schema MYUSER "C:\my.jar"
it falls into the following error
Error while creating class ids/jacksum/Crc32Q
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1
The JAR file, works fine when using from the same client toward an Oracle 12.2 database.
Does anyone knows if there is a compatibility issue between Client 12.2.0.1 and Server 19 affecting the LOADJAVA utility?
Thanks,
SimoneB
PS
I also made a test using the Client 19 and "surprisingly" it works fine: the class is correctly loaded into the database. My problem is that I cannot force my customer to update the Oracle Client version right now!