***Checked for relevance on 06-Jan-2014***



What are the Oracle Precompiler options HOLD_CURSOR and RELEASE_CURSOR  
and how do they affect the performance of a PCC program? 
 
First of all, these options apply to implicit and explicit cursors in 
all precompiled languages except Pro*Ada.  They apply ONLY to implicit 
cursors associated with INSERT, UPDATE, DELETE, or a single row SELECT 
in Pro*Ada.  An explicit cursor in a program is one explicitly created 
with EXEC SQL DECLARE C1 CURSOR FOR... 
 
This bulletin discusses what these options do internally and how changing  
them affects program performance.

HOLD_CURSOR is a precompiler command line parameter.

Summary Operation:
~~~~~~~~~~~~~~~~~~

	Statement submitted
	|
	Is it in an open cursor?--YES--&gt EXECUTE