Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


how to get the generated id from an inserted row using executescalar


how to get the generated id from an inserted row using executescalar  using -'c#,oracle,ado.net'

I know that in Oracle I can get the generated id (or any other column) from an inserted row as an output parameter.
Ex:

insert into foo values('foo','bar') returning id into :myOutputParameter


Is there a way to do the same, but using ExecuteScalar instead of ExecuteNonQuery?

I don't want to use output parameters or stored procedures.

ps: I'm using Oracle, not sql server!!!
    

asked Oct 3, 2015 by nikhilapatil
0 votes
39 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...