Reputation:
I'm coding a lot of PL/SQL blocks using explicit cursors to fill some tables... So I need a "reminder" to close all cursors. So... Is there an Oracle error code to raise when I finish a plsql block without close an explicit cursor? Thanks
Upvotes: 0
Views: 39
Reputation: 2242
No, it's not. However cursors in anonymous block are automatically closed when the blocks finish. You should explicitly close the cursors though, as it is considered good practice.
Upvotes: 1