Hello,
For a certain table I need to create a surrogate key.
I created a sequence in Oracle .... Now How can I import this sequence into DS ?
I tried doing it with : 'Select seq.nextval from dual' but that failed !
I donot want to have a DS Internal sequence as I do need this sequence accessible.
Thanks,
Importing sequences from Oracle DB
Moderators: chulett, rschirm, roy
Importing sequences from Oracle DB
Best Regards,
Lando
Lando
jzparad,
this is the error message I get when I try to 'View_Data' :
'
DS_DIM_LANGUAGE..Oracle_OCI_15: ORA-08002: sequence SEQ_LANGUAGE.CURRVAL is not yet defined in this session
DS_DIM_LANGUAGE..Oracle_OCI_15.DSLink1: DSP.Open GCI $DSP.Open error -100.'
the job Is Set :
Oracle_source, Oracle_select_sequence(My problem)
Transformer
Oracle_target
this is the error message I get when I try to 'View_Data' :
'
DS_DIM_LANGUAGE..Oracle_OCI_15: ORA-08002: sequence SEQ_LANGUAGE.CURRVAL is not yet defined in this session
DS_DIM_LANGUAGE..Oracle_OCI_15.DSLink1: DSP.Open GCI $DSP.Open error -100.'
the job Is Set :
Oracle_source, Oracle_select_sequence(My problem)
Transformer
Oracle_target
Best Regards,
Lando
Lando
Lando,
Craig's right.
What you're trying to do is similar to "select seq.currval from dual" in sqlplus and you will get the same ORA-08002 error unless you have done a "select seq.nextval from dual" in the same session. When you view the data in DataStage you are creating a new session. Hence the error.
Craig's right.
What you're trying to do is similar to "select seq.currval from dual" in sqlplus and you will get the same ORA-08002 error unless you have done a "select seq.nextval from dual" in the same session. When you view the data in DataStage you are creating a new session. Hence the error.
Jim Paradies