Oracle Error ORA-03127

[donychao]

I want to update a CLOB field using DOA in
DELPHI 5.X. I can see the text CLOB field was
updated normally(I can see it in SQL*PLus),
but When I opened the project in delphi or
run the Application , it come to an Oracle
Error ORA-03127. Can anyone tell me what
happened ? Thanks

/////////// Just for reference
ORA-03127 no new operations allowed until the active operation ends
Cause: An attempt was made to execute a new operation before the active
non-blocking operation completed or a new operation was attempted before all
the pieces of a column were inserted or fetched.
Action: Execute the new operation after the non-blocking operation completes.
If piecewise binds/defines were done, execute the new operation after all the
pieces have been inserted or fetched.

------------------

 

[Marco Kalter]

This is a bug in Direct Oracle Access that is fixed in the upcoming 3.4.4 release. It will hopefully be out in 1 or 2 weeks.

------------------
Marco Kalter
Allround Automations

 

[donychao]

After 3 months later finally I have time to
implement a LONG field to CLOB filed transfering job. Now I have a release 3.4.5,
it is much later than you sugguest.
And I still got a trouble Oracle Error:
-------------------------------------
ORA-03127 no new operations allowed until the active operation ends
Cause: An attempt was made to execute a new operation before the active
non-blocking operation completed or a new operation was attempted before all
the pieces of a column were inserted or fetched.
Action: Execute the new operation after the non-blocking operation completes.
If piecewise binds/defines were done, execute the new operation after all the
pieces have been inserted or fetched.
--------------------------
Why does such thing happens?
Can you tell me? mkalter ?

Originally posted by mkalter:
This is a bug in Direct Oracle Access that is fixed in the upcoming 3.4.4 release. It will hopefully be out in 1 or 2 weeks.

------------------

 

[Marco Kalter]

Version 3.4.4 was released in June, so I'm not sure what you mean by "much later than you suggest".

Anyway, the problem that was fixed in 3.4.4 was related to multi-byte character set databases and LOB data. If you are still getting ORA-03127, perhaps you can send me something to reproduce the problem.

------------------
Marco Kalter
Allround Automations