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..."