LookUp returning NULL when reading a seqval from dual

muascdev · Post by **muascdev** » Tue Jul 10, 2007 5:35 pm

i have a requirement where in i need to get the sequence numbers and use it for various purposes, when i use the lookup with oracle enterprise with sparse, its returning NULL. my sql is like this

select mdm_seq.nextval as TASKID, '1' as dummy from DUAL;

i also use dummy variable in the source file and hard coded that as '1' too, thought i needed to do this so lookup link can find a match in the input source, but it doesnt return the seq number. any help?

ray.wurlod · Post by **ray.wurlod** » Tue Jul 10, 2007 9:50 pm

Are you (the executing user - the user ID used to connect to Oracle) the owner of this particular sequence? You may need to qualify the sequence name with its owner's identity.