I would like to know how ORACLE handles cursors in PL/SQL packages.
When are they parsed, when are they released, are PL/SQL cursors
included in the OPEN_CURSORS count, what about implicit vs explicit
cursors etc.?
Of special interest is the difference between declaring a cursor
local to a Procedure or Function compared to declaring the cursor on
Package Body level. Is one of these ways better in terms of memory
resources, performance (parsed less times) etc.?
I am currently cleaning up a rather large PL/SQL application right now
and would like to know if I should change my local cursors to global
cursors at the same time. Appreciate any insight in this area.
Regards,
Hans
---
Hans Bergsten
Business Networks, a division of Internet : ebuhob_at_ebu.ericsson.se
Ericsson GE Mobile Communications MEMO : VAX.EBUHOB..EBU.ERICSSON.SE..INET
5757 Plaza Drive Voice : +1 (714) 236-6784
Cypress, CA 90630-0007, USA FAX : +1 (714) 236-6039
Received on Thu Jul 21 1994 - 06:39:11 CEST