PL/SQL and Bind Variables / Literals
From: Thomas Roach <troach_at_gmail.com>
Date: Wed, 17 Jun 2009 21:19:09 -0400
Message-ID: <b86ffce60906171819x6776b6ecqb8e5d3b9c2373ed7_at_mail.gmail.com>
Hi Group,
Date: Wed, 17 Jun 2009 21:19:09 -0400
Message-ID: <b86ffce60906171819x6776b6ecqb8e5d3b9c2373ed7_at_mail.gmail.com>
Hi Group,
I am looking at options on forcing Oracle to use literals inside of a PL/SQL package. I have a bind variable peeking issue that is causing a cached execution plan that doesn't work well for all scenarios. To get around this (and since the query is executed only a handful of times), I want to force the query to use literals inside of PL/SQL. One option I thought of is to use execute immediate. I was wondering if anyone had any ideas or thoughts if there is a better way to do this.
Thanks,
Tom
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 17 2009 - 20:19:09 CDT