Hello Experts,

As per my understanding, cursors cached in pl/sql cache of an anonymous Pl/SQL block are closed after execution of the block so that next execution requires library cache to be visited to confirm the presence and validity of the cursor at the location pointed to by the pointer in session cache. This causes soft parse.
On the other hand, cursors cached in pl/sql cache of a Pl/SQL block which is part of a stored procedure are kept open after execution of the block so that next execution does not require a visit to library cache for authentication. As a result soft parse is avoided.

Kindly let me know if I understand correctly

Thanks in advance
Regards
Anju Garg