Page 1 of 1

Sequence

Posted: Fri 28 Apr 2006 14:41
by hrmuhr
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.

Posted: Fri 28 Apr 2006 14:57
by Paul
There are no specific components or features for Oracle Sequence in OraDirect .NET. You have to use MySequence.NextVal directly in SQL statement