If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I am using Oracle Database 11g Release 11.2.0.4.0 - 64bit Production.
I want to raise an error in scenario:

In session 1 I update a row and do not commit.
In session 2 I run procedure where cursor selects the same row and updates it.

However in session 2 it neither updates the row, nor it raises an exception of deadlock.

In procedure in session 2, I have used forall update.
When I use simple for loop, it waits till i commit session 1 and then updates. I NEED this to be IMPLEMENTED in case of FORALL statement, as we use FORALL statement for insert and update in our project as a general rule.

Can you please help me in doing this... ?

My code using for loop :

create or replace procedure Proc_Ptemp is

Cursor c1 is
select * from ptemp;
m_SqlErrm VARCHAR2(150);
begin
for v1 in c1 LOOP
UPDATE ptemp SET d=add_MonthS(d,1);
END LOOP;
EXCEPTION
WHEN OTHERS THEN
m_SqlErrm:=SUBSTR(SQLERRM,1,200);
end Proc_Ptemp;