table sequence, renumbering

What is the absolute fastest way to populate a primary key / id column
from a named db sequence (disabled constraints and want to renumber the
primary key / id column from sequence.

cannot use auto inc or serial column because need to use generic
hibernate mapping files for multiple DB's in the end, but want a stored
proc to simple reorder a primary key int column pulling from a named
sequence, if there is a single command.

thanks


J.V.