ORA-03127: no new operations allowed until the active operation ends

[Roeland]

This error is raised when I execute this in a test window:

begin
  :mClob := 'test';
end;

This is the content when I save it:

PL/SQL Developer Test script 3.0
4
begin
  :mClob := 'test';
end;
1
mClob
1
<CLOB>
112
0

Defining "mClob" as a Clob or a temporary clob makes no difference.

This behavior is triggered by disabling "Preferences > Oracle > Options > "Unicode enabled".

When I enable it again, everything works back as normal.

From the documentation:

Unicode enabled. When selected, Unicode data will be fetched as such from the Oracle Server, and displayed as Unicode text. When disabled, Unicode data from the server will be converted to the character set of the Oracle Client, in accordance with the NLS_LANG key of the Oracle Home Registry.

Version 10.0.5.1710
Version 11.0.0.1752 Beta 2

 

[Marco Kalter]

We'll check it out.

 

[Svetlin Stefanov]

The same error occurs in Version 13.0.6.1911 (32 bit) when performing select on table that has CLOB columns with "Preferences > Oracle > Options > "Unicode enabled" disabled.
when the option is enabled, the error is not triggered.