DBMS_DDL.ANALYZE_OBJECT and implicit commit

Does the DBMS_DDL.ANALYZE_OBJECT procedure cause an implicit commit within a PL/SQL block? A procedure we developed populates several staging tables and updates some production data. I think our performance will increase if we can analyze the staging tables, but want the option to rollback all activity upon an exception. If the analyze performs an implicit commit we lose the ability to rollback everything.

Any thoughts?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 22:18:34 CST