I am adding a new package to a collection. the collection is already present in plan that I m gonna execute. So I didn't bind the plan. However I end up with -805 sql error. On looking at the logs I found that -805 is from package CAODDB8S.timestamp which is a ca optimizer ii package.
I am confused, till now my understanding is that no need to bind the plan if we add the package to a collection which is already present in plan Pklst.
btw, when I did the bind plan it solved the issue. but need to know it resolved the issue.
The DBRM of the version of the application program being executed was not bound. (A package with the same consistency token as that of the application program was not found.)
