Budjum wrote:Should work if done properly. Look very carefully on the values you are searching for - are you trying to find the '1' you started with, or are you searching for the new value 'ONE'?
Could you please suggest what can be a reason of the problem:
While data import and doing table lookup all works fine untill the column with Key value is numeric (such as surrogate PK) but if i'm trying to use varchar NK - lookup doesn't work.
It simply doesn't find the loookup value without any additionall error.
. . .
But if DICT_ID will be changed to varchar2(20) and will contain character values like below, same import flow doesn't work: