Re: DBMS_XPLAN.DISPLAY in PL/SQL?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Nov 2004 08:34:05 -0800
Message-ID: <2687bb95.0411170834.5d28ade9@posting.google.com>

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