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 -> Re: Problem with open cursors.

Re: Problem with open cursors.

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 31 Jul 2005 17:36:43 +0200
Message-ID: <dciqq2$su9$1@news5.zwoll1.ov.home.nl> 





Ach C via DBMonster.com wrote:


> Query with a returned cursor to 

> 

> application.So I do not know if I should close that cursor in application or

> no?

>  Any help will be so appreciated.

> 

> 



if is_open(p_result_cur ) then close p_result_cur ;
or similar code (for you to figure out if is_open is
a function, and an attribute - I used it as function,
could be p_result_cur.is_open


-- 
Regards,
Frank van Bortel


Received on Sun Jul 31 2005 - 10:36:43 CDT












Original text of this message













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