Gin Ng wrote:
I have a table which is referenced by several other tables. When I turn
autocommit off, do the inserts to the tables and rollback. All inserts are
rolled back except the parent table. Anyone has encountered the problem?
Gin Ng
Can you provide more details on what you are trying to do so we can
figure out what is happening. Is there a chance you could post code that
shows this behavior ?
Also are you issuing an explicit rollback call or did an sql statement
generate an exception .
Thanks,
Sunitha.