Problem reading generated keys in oracle

DSguru2B · Post by **DSguru2B** » Tue Mar 14, 2006 12:12 pm

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

kcbland · Post by **kcbland** » Tue Mar 14, 2006 12:23 pm

Verify no trailing spaces exist using TRIM and make sure case sensitivity is handled. Just like SQL, data must be exact matches.

DSguru2B · Post by **DSguru2B** » Tue Mar 14, 2006 12:40 pm

I did take care of those.
But I replaced a direct OCI lookup with a Hash, it is giving me the desired results.
So my curiousity still lies, that why was the OCI lookup not availing the purpose.

kcbland · Post by **kcbland** » Tue Mar 14, 2006 12:42 pm

Don't know, you didn't post the SQL so we can't tell. If your reference lookup was

Code: Select all

SELECT PK FROM REFTABLE WHERE UniqKey=:1

then the issue might be that UniqKey is padded, or :1 contains spaces. If that wasn't your SQL, then please share.

ogmios · Post by **ogmios** » Wed Mar 15, 2006 3:04 am

Answer is easy, had it already a few times... in Oracle whatever you read within 1 query is the data that existed at the moment the query was started.

Ogmios