Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Explain Plan Failure due to bind variable
1443131_at_usenetplanet.com wrote:
>
> In some cases, explain plan like below fails due to undeclared bind
> variable in session.
>
> explain plan set statement_id = 'some_id'
> for select * from some_table where some_column = :SOME_BIND_VARIABLE;
>
> However, in some cases it works even though the bind variable is not
> declared in current session. I have no clue what makes this
> difference. Could somebody enlighten me why? Thank you in advance.
Maybe you could post the error text etc.
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Mar 07 2002 - 13:04:25 CST
![]() |
![]() |