Return Oracle Sequence Nextval into C# Variable

Question

I'm trying to return the nextval from an oracle sequence and save the value into a variable, I´m not expert using Oracle with C# until now I have the connection done and I've used some Oracle packages with c#.

I know that I can use the [sequence_name].nextval into the insert query but for bussiness logic I need the same sequence number for many records and the idea is store the nextval into a variable and pass it like parameter to another c# function that will gonna be the responsible to insert the "n" records into the table.

Any hint or code example gonna be helpful, thanks a lot for the help.

PinBack · Accepted Answer · 2017-04-25 14:27:18Z

10

You can get nextval with an OracleCommand

OracleCommand loCmd = Connection.CreateCommand();
loCmd.CommandType = CommandType.Text;
loCmd.CommandText = "select seqname.nextval from dual";
long lnNextVal = Convert.ToInt64(loCmd.ExecuteScalar());

answered Apr 25, 2017 at 14:27

PinBack

2,58415 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mitch3091 Over a year ago

perfect I was missing the cmd.ExecuteScalar() part thanks a lot!

Collectives™ on Stack Overflow

Return Oracle Sequence Nextval into C# Variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related