Re: Cursor sharing

From: Olivier Berthommé <>
Date: Fri, 23 May 2014 01:03:13 -0700 (PDT)
Message-ID: <>


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

Original text of this message