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.