ORACLE SEQUENCES IN EXCEL
 

Hi all:

Is there anyway I can access a sequence of Oracle, make a nexval over it and
use that value in Excel (and update the value of the sequence in Oracle)?

Which reference library should I load?

Thanks,

ORACLE SEQUENCES IN EXCEL
 

You can get the next value (and increment the sequence) using ADO and
something like:

select seq_name.nextval from dual

Tim




--
Tim Williams
Palo Alto, CA


"Román Valoria" wrote in message
...
Hi all:

Is there anyway I can access a sequence of Oracle, make a nexval over it
and
use that value in Excel (and update the value of the sequence in Oracle)?

Which reference library should I load?

Thanks,