LookUp returning NULL when reading a seqval from dual
Posted: 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?
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?