Having used Oracle's PL/SQL, I can't really see a use case for this kind of language. Your application logic should be kept within your application, not on your database.
The exception to this of course being unless your application is already on your database.