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: DBMS_XPLAN.DISPLAY in PL/SQL?

Re: DBMS_XPLAN.DISPLAY in PL/SQL?

From: Ibrahim DOGAN <idogan_tech_at_yahoo.com>
Date: 17 Nov 2004 12:16:57 -0800
Message-ID: <6bf58828.0411171216.379cad93@posting.google.com> 





this gave error "identifier dbms_xplan_type_table" must be
identified..



bu Alberto's code worked..it's great to be able to display query plans
in a proc this way..



i.d.



> 

> declare

>   x dbms_xplan_type_table;

> begin

>   x := dbms_xplan.display

> end;

> 

> or thereabouts...

> 

>

Received on Wed Nov 17 2004 - 14:16:57 CST












Original text of this message













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