It is very reusable which I like. We have a vast store of SQL code lying around that we can adapt. Best of all, our enterprise system interface is written in Oracle Forms, which is all PL/SQL. We can mine procedures and functions all day.
My problem is dealing with cursors passed to Groovy. They were fast when we started but kept modding the queries which slowed them down. In hindsight, I should have used XML. Live and learn. Never pass cursors.
Yeah, I learned that one a long time ago, too. Just can't get decent performance with them.