Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_XPLAN.DISPLAY in PL/SQL?
idogan_tech_at_yahoo.com (Ibrahim DOGAN) wrote in message news:<6bf58828.0411161547.3e077fd4_at_posting.google.com>...
> is there a way to call DBMS_XPLAN.DISPLAY within a pl/sql procedure ? if so how?
>
> thanks in advance,
> i.d.
I believe that you call the routine the same way you call any other Oracle packaged function. You need to define a receiving field of the correct type: DBMS_XPLAN_TYPE_TABLE, and then process the returned data as necessary for your requirements.
HTH -- Mark D Powell -- Received on Wed Nov 17 2004 - 10:34:05 CST