> I'm attempting to load an oracle database and am struggling > with how to retrieve a sequence for a table. > > in SQL, the value is net_seq.nextval > how do i use this in a perl script??
Do you have DBI installed? What have you tried? Can we see some code? AFAIK, you can't directly retrieve the value of a sequence... The only way I've ever used sequences is by setting something to either net_seq.currval or net_seq.nextval - if there is a way to directly get the current value with a select statement, I don't know the syntax for it... HTH, -dave -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
