Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Store outline not used in PL/SQL

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US