selecting value.nextval using the microsoft oracleclient

[bryanhale]

I want to set nextval and return this to the vb.net program. Can I just do this with a data reader?

I assume if I have to use executenonquery i wouldn't be able to get the value back so would have to use that in combination with currval?

Does anyone have some example code (without using next val as part of an insert/update statement. Eg make use of this sql...

SELECT forwarding_log_seq.NEXTVAL as forwarding_log_id FROM dual

Cheers

Bryan