关于过程中显式打开的游标，会自动关闭吗？

heelin

问题：
1、过程中显式打开的游标，如果没有显式关闭，那么过程结束后游标会自动关闭吗？
2、如果过程返回的是游标，那么如何关闭游标，或者说系统会自动关闭游标？

kevinlin.ora

1.Closing a Cursor
Closing a cursor makes its information inaccessible and deallocates the memory that it
uses. After a cursor opens, it does not close until the user program terminates its
connection to the server.
An OCI program or precompiler application that follows good programming practice
explicitly closes open cursors during program execution. If the program terminates
without closing an open cursor, then that cursor closes implicitly.
Canceling a Cursor
Canceling a cursor frees resources from the current fetch.The information in the
associated private area is lost but the cursor remains open, parsed, and associated with
its bind variables.

In general, applications should close all open cursors that will not be used again to free
the persistent area and to minimize the memory required for application users.

note:  information above  derived from Oracle11gr2 Concepts & Oracle11gr2 Advanced Application Developer's Guide and only for reference