PL/SQL- cursors and commits

2003-04-04 Thread Wiegand, Kurt
Title: PL/SQL- cursors and commits I've been 'experimenting' with the following code in 8.1.5 and it seems to work fine. However, my ORACLE PL/SQL book from O'REILLY (Steven Feuerstein Bill Pribyl 1997) leads me to believe that it should not work. They state As soon as a cursor

Re: PL/SQL- cursors and commits

2003-04-04 Thread Reginald . W . Bailey
] Sent by: cc: [EMAIL PROTECTED] Subject: PL/SQL- cursors and commits om

RE: PL/SQL- cursors and commits

2003-04-04 Thread Ashish
Title: PL/SQL- cursors and commits As the book says, it fails with following error(9.2.0.1 on Win2k). declare*ERROR at line 1:ORA-01002: fetch out of sequenceORA-06512: at line 12 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Wiegand, KurtSent

RE: PL/SQL- cursors and commits

2003-04-04 Thread Ganesh Raja
-8413HP : +65-9067-8474 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of AshishSent: Saturday, April 05, 2003 12:19 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PL/SQL- cursors and commits As the book says, it fails with following