Hi.

Instead of creating temporary tables using dynamic SQL, why not use global temporary tables:

http://www.oracle-base.com/articles/...raryTables.php

It's going to be allot faster than issuing DDL statements.

Cheers

Tim...