Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_XPLAN.DISPLAY in PL/SQL?
Ibrahim DOGAN wrote:
>
> 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...
> >
> >
you'd need to grant privs on the type appropriately
-- Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald_at_yahoo.com Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------Received on Thu Nov 18 2004 - 06:55:11 CST