Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.oracle.server > #9282

Read Cursor

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> (permalink)
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

Show key headers only | View raw


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.  

Back to comp.databases.oracle.server | Previous | Next | Find similar


Thread

Read Cursor Harshan Eppurath <harshan.eppurath@gmail.com> - 2024-01-15 23:01 -0800

csiph-web