I don't think that your series of statements constitutes a proper
transaction, as DDL has always been a transaction on it's own, and
probably always will be. Otherwise Oracle is going to compromise
database integrity.

Why do you need DDL in your 'transaction'? in Oracle you don't need
temporary tables.

--
Sybrand Bakker
Senior Oracle DBA