>Then you have zeroed out all your options. I suggest adding another column to the Oracle table[s] and use integers as your surrogate PK. Otherwise you have to change to data type of the key field to CHARacter. PK data types of varchar2 are generally a bad idea.

I agree 100% that varchar as a PK is a bad idea. Currently I am working on a support application to another app that controls the Oracle database. I am going to try to add my own key fields and see if it has any effects on the original app. Is there a way to use a sequence as a default field value in Oracle? If not, then I'm not sure how I can insert values into the new surrogate key fields since I'm not in control of inserting the records. Thanks for the help..

-David-