hi all,

I could debug the entire pl/sql procedure and found that the
following delete statement is causing the oracle error: ora-03113.
---------------
delete FROM PROPERTIES_TEXT_LARGE a WHERE exists
(SELECT b.valueobjecttypeid, B.valueobjectid FROM PROPERTIES_OBJECTS b WHERE b.objecttypeid = 10217 AND b.valueobjecttypeid > 40000
and a.objecttypeid = b.valueobjecttypeid and a.objectid = b.valueobjectid);
---------------

This delete statement is a part of bulk deletes and almost 25-30 similar delete statements form the entire transaction. So if any of the delete stmts fails then the entire transaction rolls back. I was able to run the bulk deletes after commenting out this delete stmt. The unique property of this statement is that it has a field of type varchar2(4000) and at a given time we are deleting say only 20 records from this table. It seems there is some problem with the joining of the two tables in the delete stmt. If i delete from the same table without the join then it works fine but i cant do that all the time. I was using an "in" stmt inplace of the "where exists" but even after changing the "in" with "exists" the error still occurs.

pls send your views...

thanks for all ur earlier responses!

Parijat Paul