After commit statement

On June 9, 2009 / By admin / In Oracle / Reply

What will happen after commit statement ?

 

Cursor C1 is
Select empno,
ename from emp;
Begin
open C1; loop
Fetch C1 into
eno.ename;
Exit When
C1 %notfound;—–
commit;
end loop;
end;
The cursor having query as SELECT …. FOR UPDATE gets closed after COMMIT/ROLLBACK.
The cursor having query as SELECT…. does not get closed even after COMMIT/ROLLBACK.

Related posts:

  1. What is the Bug List page? Change Columns: by selecting this link, you can show...
  2. What is The Bugzilla Query Page? The Bugzilla Query Page is the heart and soul...

Related posts brought to you by Yet Another Related Posts Plugin.

Reply

Spam Protection by WP-SpamFree