Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Store outline not used in PL/SQL
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
![]() |
![]() |