SQL & PL/SQL

Hi,

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