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

Last updated on APRIL 13, 2020

Applies to:

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

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