View previous topic :: View next topic
|
Author |
Message |
yugendran
New User
Joined: 14 Dec 2007 Posts: 51 Location: indore
|
|
|
|
Hi guys
I am trying understand the below issue
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.
Thanks.
Yugendran |
|
Back to top |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
This should help. Look at reason code 3 :
Quote: |
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.) |
|
|
Back to top |
|
|
|