appreciate your reply, but it was like that before I began changing it....we have decided here to modify some of our apps and take advantage of Oracle's caching capabilities - we are trying to minimize db queries....parameter objects are being implemented everywhere, but this is the first time I am trying to pass a statement.