My Oracle Support Banner

Loading Java Functions Through Msql Generates POL-4202 Subsequently (Doc ID 946969.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle Lite - Version 10.3.0.2.0 to 10.3.0.2.0 [Release 10.3]
Information in this document applies to any platform.
Affected Database: Oracle


Symptoms

-- Problem Statement:
On 10.3.0.2 in Production:
When attempting to run Select/update/Insert/delete after creating a synonym on a Java Store
Function the following error occurs:

ERROR
[POL-4202] can't update while select is active in read-commited mode.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. msql system/< password >@odbc:polite:< USER00 >
2.CREATE OR REPLACE JAVA CLASS USING
BFILE('C:\SRS\oldb_before_issue\< USER >','com_rep_get_param_desc_fun.class');
3.CREATE OR REPLACE FUNCTION COM_REP_GET_PARAM_DESC_FUN(PARAM2 VARCHAR2,PARAM3 VARCHAR2,PARAM4
INT) RETURN VARCHAR2 AS LANGUAGE JAVA NAME
'com_rep_get_param_desc_fun.spcom_rep_get_param_desc_fun(java.sql.Connection,java.lang.String,java.l
ang.String,java.lang.Integer) return java.lang.String';
4.CREATE PUBLIC SYNONYM COM_GET_PARAM_DESC_FUN FOR COM_REP_GET_PARAM_DESC_FUN;
5.commit;
6. Run DML on the olite DB.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.