Re: avoid dynamic SQL
Date: Wed, 1 Jul 2009 10:52:27 +0200
On Wed, Jul 1, 2009 at 08:16, Jurijs Velikanovs <j.velikanovs_at_gmail.com>wrote:
> begin execute immediate 'alter session set cursor_sharing=''FORCE'''; end;
> Would be a quick fix. In your case.
> No it wouldn't. 1+2+3 and 1/2+2+3 would still be non-shareable. Well,
maybe: It might reduce the number of cursors somewhat, but if the data (formulae) change in subtle ways, the errors might reoccur, then disappear again, making diagnostics much harder. Not to mention the side effects of this setting on the other SQL that runs in the same session. Sure one can turn it to FORCE and back to EXACT for every statement, but that's two statements too many...