Originally posted by slimdave
i) use a data type that is appropriate for the data being stored.
ii) if your pk is synthetic, and thus probably numeric, then NUMBER is evidently the correct choice.
AMEN!