I am looking up a table with Pk's generated through Oracle NextVal seq ( not done through DS ETL). For some reason the driving data with unique column is not joining with the lkp table also having that unique data.
SRC:
UniqKey
A
B
C
LKP:
PK UniqKey
1 A
2 B
3 C
Problem reading generated keys in oracle
Moderators: chulett, rschirm, roy
Problem reading generated keys in oracle
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Verify no trailing spaces exist using TRIM and make sure case sensitivity is handled. Just like SQL, data must be exact matches.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Don't know, you didn't post the SQL so we can't tell. If your reference lookup was
then the issue might be that UniqKey is padded, or :1 contains spaces. If that wasn't your SQL, then please share.
Code: Select all
SELECT PK FROM REFTABLE WHERE UniqKey=:1
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle