ORA-01001: invalid cursor ORA-06512

I am using ODP.net and randomly receive the following error:

ORA-01001: invalid cursor ORA-06512

when trying to execute a stored procedure with this structure:

CREATE OR REPLACE PROCEDURE ...
AS
 BEGIN
update ...
where ....

update ...
where ....
and
(
exists (select .... WHERE ....)
or ....
);
END; After it happens the first time the the error repeats itself until I restart the oracle service. Version 10.2

I am new to oracle and dont even understand why there is a cursor error when I am not even using cursors.

Any ideas?

Thanks Received on Fri Jun 16 2006 - 15:49:43 CDT