Re: Store outline not used in PL/SQL

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 5 Apr 2007 20:52:28 -0700
Message-ID: <1175831548.020867.104130@d57g2000hsg.googlegroups.com>

On Apr 6, 3:32 am, matta..._at_gmail.com wrote:
> I should have also stated that this is RedHat 3 Update 7.

PL/SQL "rewrites" embedded SQL - changes case and formatting - so it doesn't match the statement, for which the outline was created. You need to take the actual statement from the shared pool and create the outline for it.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Thu Apr 05 2007 - 22:52:28 CDT