Create table using %TYPE in dynamic SQL

Hi all,

It seems I've run into a problem of lack of flexibility in SQL itself. I'm no whiz, but I'd like to retain the flexibility that comes from using %TYPE where appropriate.

However, it seems I cannot use this in "create table" statements. "CREATE TABLE t_result_r35 (eqp_code mtf_equipment.eqp_code%TYPE)" just results in an "invalid character" error.

I'm executing this "immediately" in PL/SQL. In case there is no way to solve this in SQL directly, is there any way I can get the data type as a string value?

-- 
Victor Engmark
Get Firefox (http://www.spreadfirefox.com/?q=affiliates&id=7135&t=67)!