Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: USER_BIND_PEEK_MISMATCH...
<snip>
> The query is using bind variables, that can have some different
> values. These values depend from the process type and are the same in
> all environments.
<snip>
...
> But we have always the same values of the binds, so I do not
> understand why we have sometimes 1 and sometimes a lot of child
> cursors.
<snip>
Elena,
Please reference http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:9497064796920 It sounds like you are saying bind values do change, so you can expect mismatches when variations of values come up. Received on Tue Jun 26 2007 - 12:45:55 CDT