Using Oracle 10g. The original Oracle designer for this project has advanced, and those of us who remain are a reasonable developer for Oracle, but we need help setting up and planning.
We have separate procedures in โsimilarโ packages, some of which have grown in size to include many (50 ish) procedures with various complexities.
At this point, several small procedures (select the ID from the Contract, where Item = 'xyz') in these large packages will take much longer than expected from within these packages (from TOAD, SQL Developer, or from .NET Oracle Provider) than with compiling proc yourself or in a smaller package. (Tables are indexed)
Should there be costs to use such large packages even when calling relatively simple separate procedures, or is there some โotherโ factor that we should look for?
(note: an upgrade to Oracle 11 is planned, but not "inevitable")
source share