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

From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 26 Nov 2019 07:48:29 -0500

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

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

References:
- Query with Bind variables hangs but hard coded literals works fine
  - From: Steve Wales (AddOns)
- Re: Query with Bind variables hangs but hard coded literals works fine
  - From: Jonathan Lewis

Other related posts:

» Query with Bind variables hangs but hard coded literals works fine- Steve Wales (AddOns)
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Stefan Koehler
» Re: Query with Bind variables hangs but hard coded literals works fine- Jonathan Lewis
» Re: Query with Bind variables hangs but hard coded literals works fine- Neil Chandler
» Re: Query with Bind variables hangs but hard coded literals works fine- Jonathan Lewis
» Re: Query with Bind variables hangs but hard coded literals works fine- Andy Sayer
» Re: Query with Bind variables hangs but hard coded literals works fine - Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Chris Taylor
» Re: Query with Bind variables hangs but hard coded literals works fine- Andy Klock
» Re: Query with Bind variables hangs but hard coded literals works fine- Andy Wattenhofer
» Re: Query with Bind variables hangs but hard coded literals works fine- Ethan Post
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala
» Re: Query with Bind variables hangs but hard coded literals works fine- Chris Taylor
» Re: Query with Bind variables hangs but hard coded literals works fine- Steve Wales (AddOns)
» Re: Query with Bind variables hangs but hard coded literals works fine- Mladen Gogala