Can I add records via SQL Script?

[Hillary]

I have a table Part_Location which has Part_ID, Location_ID and Warehouse_ID as primary keys.

Because of barcoding, I would like to change the Location_ID from LOW VOLUME to LV. When I run the Update statement, Update Part_Location
Set Location_ID = 'LV'
Where Location_ID = 'LOW VOLUME'; I get an Oracle error,

^
Error: ERROR 24537 NOT FOUND IN ERROR.SQL (transaction rolled back).

So what I think I need to do is to create a Part_Location LV for every Part_ID that has a Part Location of LOW VOLUME.

Is there a way to do that???

Thanks,

Hillary

 

[RiverGuy]

It could be that you are attempting to break the uniqueness of your primary key. You could be updating rows in which the key would not be unique.

 

[PHV]

This may also be an integrity referential error if Location_ID is part of a Foreign Key elsewhere.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244