ora-03127

[huxiba]

I have a db function which return clob ,
in my java program , it's work . but when I test it from the test windows, I got ora-03127.

pl/sql developer version:6.0.6.947
and a post here about this.

 

[Marco Kalter]

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[--Adrian]

I am getting this error when calling a procedure in a test window that passes a clob back via an OUT parameter.

PL/SQL Developer
Version 7.1.0.1337

 

[Marco Kalter]

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[Lachlan]

I was also getting this problem. It turns out, that as our databases we work with are UTF8, I changed my registry settings as per the warning message to UTF8. That is when I got this message. If I change it back to my original setting of WE8MSWIN1252, I no longer get this message.

I tried with the latest 1339 build of 7.1.1

 

[Martin Dratva]

Hello.

I am getting this error in version 7.1.5.

PL/SQL Developer
Version 7.1.5.1398
01.51898 - 1 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 3)

Physical memory : 2

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[Martin Dratva]

I have sent it to you.

 

[Invincible]

I'm experience same problem - when my query returns CLOB result PL/SQL developer gives me an error "ORA-03127: no new operations allowed until the active operation ends"
example :
select dbms_metadata.get_ddl('VIEW','ALL_TABLES', 'SYS') from dual;

it returns me only a part of clob.
this works as
select to_char(dbms_metadata.get_ddl('VIEW','ALL_TABLES', 'SYS')) from dual;

PL/SQL Developer
Version 8.0.1.1502

Character Sets
Character size: 3 byte(s)
CharSetID: 0
NCharSetID: 873
Unicode Support: False
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

 

[Invincible]

Fixed with Unicode Enabled (checked).

 

[Erik B.]

I have the same error when I use a test window with a clob as output...

Unicode is allready enabled, and I use the latest client.

How can I fix this problem?

Here are the details:

PL/SQL Developer
Version 7.1.5.1398
01.51825 - 10 user license
Windows Vista (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (4,194,304 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,825,528 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\ebruinsma\default.ini

Plug-Ins

Aliases
CASE10G
DO03
DO04
DP04P
DT04
EXTPROC_CONNECTION_DATA

Homes
OraClient11g_home1 (E:\app\ebruinsma\product\11.2.0\client_1)

DLLs
E:\app\ebruinsma\product\11.2.0\client_1\bin\oci.dll

TNS File
E:\app\ebruinsma\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: E:\app\ebruinsma\product\11.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

Character Sets
Character size: 3 byte(s)
CharSetID: 871
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.UTF8
NLS_CHARACTERSET: UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16