I've been told that the app processes its records on by one for "safety reasons" (whatever that means!), but I'd expect the code to parse its SQL once and then run against the record set like you would do in PL/SQL, thus reducing soft parses and so latching etc.
Does anyone know if this is possible in when the SQL is coming from Java. I know nothing about Java really, but my thoughts are this is a technique that could be applied in Java, rather than a constraint of the language?
My interest is in the database side of things where I'm seeing the beginnings of a latching issue that I don't want to come and bite us later if the application has to scale up.