Re: Cursor sharing
From: Olivier Berthommé <olivier.berthomme_at_gmail.com>
Date: Fri, 23 May 2014 01:03:13 -0700 (PDT)
Message-ID: <aa4fda5e-ef6a-4508-9383-9d6b0a09b1db_at_googlegroups.com>
Date: Fri, 23 May 2014 01:03:13 -0700 (PDT)
Message-ID: <aa4fda5e-ef6a-4508-9383-9d6b0a09b1db_at_googlegroups.com>
Hi,
One possible reason of not binding literals is executing SQL inside anonymous PL/SQL block. Read doc ID 285447.1 I've see this behavior even in an Oracle 11gR2 and with cursor_sharing=force... DBA can't do anything ; bad SQL development !
Other point matching your issue : queries are with in non equality predicates (eg >, <, >=, <=, LIKE). See doc ID 364845.1
Olivier Received on Fri May 23 2014 - 10:03:13 CEST