We don’t like writing fix values in your tool for input parameters and than again in result queries because of great probability of mistyping. We save value of procedure parameters in table. So if we have procedure mypack.myproc(p_id in number) where p_id is id of same table, it is more likely that we will need to use that id in our result in the part “Data changed by program”. Normally we have all the data in table rows, so we send only id to procedure that make changes in some rows in tables which are restricted by that id.
Is there any option that you upgrade your program with this functionality?