Re: Explain Plan Failure due to bind variable

On Thu, 07 Mar 2002 16:10:18 GMT, 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.
>
>
>
>
>

No, as you provide no clues to resolve it. No platform, no version etc, etc, etc.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 07 2002 - 12:24:38 CST