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

 

bye

TPD

Comments

Vote history