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

Home -> Community -> Usenet -> c.d.o.server -> Ref Cursor Performance Question

Ref Cursor Performance Question

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Wed, 13 Jun 2001 16:44:05 -0700
Message-ID: <3B27FAC5.23D2A397@attws.com>

Has anyone benchmarked the performance difference, if any, between regular cursors:

CURSOR xyz IS

   SELECT .... and ref cursors

OPEN ref_cursor FOR

   SELECT .... if your processing is entirely within a code block and not being used to return values to a front-end program.

If not ... I'll be doing it tomorrow.

Thanks,

Daniel A. Morgan Received on Wed Jun 13 2001 - 18:44:05 CDT

Original text of this message

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