getting sequence number from oracle

[stefes007]

Hi, I need to get a sequence.nextval from an oracle sequence for a form in access. Access is already connected to this oracle database because there a re linked tables, but i d'ont have any idea how to submit queries as "select sequence.next into :bob from dual" ...

Thanks for your help !

Dekeyzer Stephane.
Belgium

 

[taupirho]

Check out thread222-869320
Its about getting XML data into Oracle using VB but should give you some useful pointers.