Oracle PL/SQL giving null values a numeric value in a stored proceedure

I am hoping I can get someone to give me some insite on a stored proceedure I am writing.
I have a table that was created by the all knowing contractors within an Oracle database in an Arbor Billing System. The table was created and a primary key was set for a numbering scheme from aproximatly 32,000 to -32,000 except that the numbers are only created when a row is created in the table. The problem I have is that there are different number ranges being used randomly for row entries and null values in between.

I am tring to create a stored proceedure to assighn numeric values to the random Null values in the sequence of the table.

I have had a couple of Ideas one of which was to create another table with all of the numbering sequence in tact and have and inner join pull the values from that table where the value IS NULL for the table in question. Received on Wed Jan 23 2002 - 09:26:52 CST