Sequence

hrmuhr · Post by **hrmuhr** » Fri 28 Apr 2006 14:41

Hi,

How can I use Oracle Sequence with parameters, like that.

Mycmd.Parameters['id'].Value := MySequence.NextVal;
Mycmd.Parameters['name'].Value := Text1.text;

I need some example,

Thanks.

Paul · Post by **Paul** » Fri 28 Apr 2006 14:57

There are no specific components or features for Oracle Sequence in OraDirect .NET. You have to use MySequence.NextVal directly in SQL statement