Re: Query with Bind variables hangs but hard coded literals works fine

That is actually very simple to explain. Since this is the ERP package and Steve cannot change the code, all bind variables must be coming from CURSOR_SHARING=FORCE. That is the only way how to introduce the bind variables without changing the code.

On 11/26/19 5:12 AM, Jonathan Lewis wrote:
> One other point I forgot to mention.
>
> It's a little unusual to see "rownum < :bindvariable". Do the bind variables take the form :SYS_B_nnnn ? This would indicate that they have been created by Oracle in response to the cursor_sharing parameter being set to something other than EXACT.
>
> Regards
> Jonathan Lewis
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l