PL/SQL: How to open two cursor on the same table?

basically what I want to do is open to cursors on the SAME TABLE with PL/SQL

cursor1 is select ... from emp
cursor2 is select ... from emp

open cursor1 loop

    open cursor 2 loop

        update(...)
        commit

end loop

The problem is that each statement/curosr on it's own works fine but when they are combined like the way described above they seem to lock each other.

Isn't there a way to solve this - more or less - common problem? Or am I missing an important point here?

Thanx for a hint

Oliver

pistor_at_dsa-solutions.de
http://www.dsa-solutions.de

Fon: +49 6221 839 513
Fax: +49 6221 839 515 Received on Fri Jan 21 2000 - 12:04:20 CET