Re: avoid dynamic SQL

  • From: Vladimir Andreev <vandreev@xxxxxxxxx>
  • To: j.velikanovs@xxxxxxxxx
  • Date: Wed, 1 Jul 2009 10:52:27 +0200

On Wed, Jul 1, 2009 at 08:16, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx>wrote:

> begin execute immediate 'alter session set cursor_sharing=''FORCE'''; end;
> /
> Would be a quick fix. In your case.
> Yury
> 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...


Other related posts: