Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: USER_BIND_PEEK_MISMATCH...

Re: USER_BIND_PEEK_MISMATCH...

From: <dday1960_at_gmail.com>
Date: Tue, 26 Jun 2007 10:45:55 -0700
Message-ID: <1182879955.317638.132110@j4g2000prf.googlegroups.com>


<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US