Can somone confirm for me that, although PL/SQL improves performance for multiple database actions performed together, it will actually decrease performance over a direct query for a large query, say, over a thousand rows, that has nothing done to it except returning to the calling program? This must be the case, since the data is first loaded by basic sql processing, and then moved to buffers controlled by PLSQL, but I would like a confirmation of some sort.
In this case the calling program is a jdbc driver.
Thanks for any info. --Simmie