Skip navigation

add FINALLY key word

score 60
You have not voted. Active

I often face the problem that I Open a cursor and this could fail (e.g. with no rows returned)

But I'd lke the close of this cursor to be executed any way.


Currently I have to write the close statement twice: once in the "happy path" and again in the EXCEPTION block. This also implies that I need an exception bblock just for closing the cursor.


Please add the FINALLY key word.


Allow the FINALLY key word in front of a single statement to ensure that this statement is executed even when an exception occured before within this procedure/function. This may be coupled with the CLOSE key word.

Multiple FINALY (CLOSE) statements should be allowed within a block.


Alternatively add the FINALLY keyword as a part of an PL/SQL block just like EXCEPTION where I can place statements that should be executed even if an exception has been raised





Vote history