Error ORA - 03127
569125Apr 30 2007 — edited Apr 30 2007Hi,
I am facing error ora-03127 no new operations allowed untill the active operations end while selecting from table, after updating data in clob columns.
Table structure is as follows :
prj_operations_plan
---------------------------
plan_id varchar2(30)
oper_id varcahr2(30)
updt_no number(3)
text clob
sd_var sd_obj
* Here I am appending some texts to the "text" clob data.
* Proc is executed without any error.
* I got all texts appended in "text" column.
But when I have fired select query in table like ( in plsql developers's sql window)
select * from prj_operations_plan;
It gives me above mentioned error.
Kindly help.
Regards,
Rushang.
Message was edited by:
Rush