Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Cursor performance in Oracle

Re: Cursor performance in Oracle

From: Mark Gumbs <mgumbs_at_nospam.hotmail.com>
Date: Wed, 9 Jun 1999 08:58:57 +0100
Message-ID: <375e1c6f.0@145.227.194.253>


Also, if you use an implicit cursor inside a form, ie on a Post-Query trigger, it may slow the app down since the implicit cursor does one fetch to see if any too_many_rows exception needs to be raised and then another to fetch the data. Doubles up on work.
With an explicit, there is no such problem.

M Received on Wed Jun 09 1999 - 02:58:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US