How can I capture DBMS_XPLAN.DISPLAY output into a table - e.g. as a CLOB? select * from table(dbms_xplan.display); ___________________________________________________________ All New Yahoo! Mail ? Tired of Vi@gr@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html -- //www.freelists.org/webpage/oracle-l