If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Urgent help needed!!

I'm trying to write an Oracle procedure to do the following and I'm having some trouble. Here's the problem:

I have a table that contains an item number and a location number. I want to take each of the item numbers and look in another item cross reference table to see if it exists. If so, I want to update the original item number with the new one. I need to do this same thing for the location numbers, which have another separate cross reference table. If either the item or location numbers do not exist in the cross reference tables, update a column in the original table with a status of FAIL, or something like that.

I have a table that contains an item number and a location number. I want to take each of the item numbers and look in another item cross reference table to see if it exists. If so, I want to update the original item number with the new one.

"If so, I want to update the original item number with the new one." In which feild???

This is odd...I ran this query against a table I had created to hold the xref numbers, and it worked great. Now, I point it to a real xref table and it doesn't update anything, even though both the xref table and the source table have an item called 'XYZ' for example.