Re: package invocation CALL vs EXEC
From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Wed, 4 Feb 2015 13:49:48 -0500
Message-ID: <CAMHX9J+zCxV4UDH=2MJq4wJumdbngJiH2NJM2LU4QAOCqZ8Rtg_at_mail.gmail.com>
You can check if you get two (or more) child cursors for your SQL query (and use v$sql_shared_cursor to see why).
Date: Wed, 4 Feb 2015 13:49:48 -0500
Message-ID: <CAMHX9J+zCxV4UDH=2MJq4wJumdbngJiH2NJM2LU4QAOCqZ8Rtg_at_mail.gmail.com>
You can check if you get two (or more) child cursors for your SQL query (and use v$sql_shared_cursor to see why).
On Wed, Feb 4, 2015 at 1:45 PM, Ls Cheng <exriscer_at_gmail.com> wrote:
> hmm
>
> I didnt flush the shared pool.
>
> What I did was
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2015 - 19:49:48 CET