> Why not use the the table column type?
> Oracle has this feature:
>
> Columname table.column%type;

I also like it. But without "%type" :) I.e.

DECLARE <varname> TYPE OF <tablename>.<columnname>

Adriano, what do you think ?

Regards,
Vlad