Re: Query with Bind variables hangs but hard coded literals works fine
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 26 Nov 2019 11:05:54 -0500
Message-ID: <df1e0583-5e14-98f9-73c7-141e47569e0f_at_gmail.com>
Date: Tue, 26 Nov 2019 11:05:54 -0500
Message-ID: <df1e0583-5e14-98f9-73c7-141e47569e0f_at_gmail.com>
He's probably using the "ALTER SESSION" version. He says that the code is a part of an ERP package and that he cannot change the code. There is no other way to alternate between the literals and bind variables. Doing alter system would be very clunky indeed, but still possible.
On 11/26/19 10:43 AM, Andy Wattenhofer wrote:
> This was going to be my question as well, do you have
> cursor_sharing=FORCE?
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 26 2019 - 17:05:54 CET