Re: avoid dynamic SQL
From: Vladimir Andreev <vandreev_at_gmail.com>
Date: Wed, 1 Jul 2009 10:52:27 +0200
Message-ID: <442adaf60907010152r1e322bdy372404bb4235b8ce_at_mail.gmail.com>
On Wed, Jul 1, 2009 at 08:16, Jurijs Velikanovs <j.velikanovs_at_gmail.com>wrote:
Date: Wed, 1 Jul 2009 10:52:27 +0200
Message-ID: <442adaf60907010152r1e322bdy372404bb4235b8ce_at_mail.gmail.com>
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.
>
> 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...
Cheers,
Flado
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 01 2009 - 03:52:27 CDT