X-Received: by 2002:a05:622a:309:b0:429:f5d9:aacf with SMTP id q9-20020a05622a030900b00429f5d9aacfmr11075qtw.8.1705388461404; Mon, 15 Jan 2024 23:01:01 -0800 (PST)
X-Received: by 2002:a05:6214:2629:b0:681:3668:9159 with SMTP id gv9-20020a056214262900b0068136689159mr674599qvb.2.1705388461166; Mon, 15 Jan 2024 23:01:01 -0800 (PST)
Path: csiph.com!weretis.net!feeder6.news.weretis.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.oracle.server
Date: Mon, 15 Jan 2024 23:01:00 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=202.164.131.36; posting-account=SpjKDgoAAAD_ARwFNgFtCCXyhrf1Y--X
NNTP-Posting-Host: 202.164.131.36
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <dc92bb9c-6edb-4d13-a148-eca4f2ffca1dn@googlegroups.com>
Subject: Read Cursor
From: Harshan Eppurath <harshan.eppurath@gmail.com>
Injection-Date: Tue, 16 Jan 2024 07:01:01 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1157
Xref: csiph.com comp.databases.oracle.server:9282

It is my finding that too many ( say more than 1000) insert/updates/deletes inside a read cursor can create problems. You may have to do add extra logic for this to work.