c# insert row into Oracle table

Question

I have oracle table named Query_Times. So i create TableAdapter using VS2010, and add insert query to it:

INSERT INTO QUERY_TIMES (ID, QRY_TIMESTAMP) VALUES (1, @qry_time)

QRY_TIMESTAMP is timestamp(6) data type.

In code i try to execute query like this:

QUERY_TIMESTableAdapter tblqry_times = new QUERY_TIMESTableAdapter();
tblqry_times.InsertQryTime(currTime);

but i got an error Message=ORA-01036: illegal variable name/number.

How to correctly define parameter to use it in a query?

C.Evenhuis · Accepted Answer · 2011-07-05 06:57:13Z

0

Oracle uses the : parameter prefix (see http://dotnetfacts.blogspot.com/2009/01/adonet-command-parameters.html)

answered Jul 5, 2011 at 6:57

C.Evenhuis

26.4k2 gold badges60 silver badges73 bronze badges

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

1 Comment

Nikita Over a year ago

my big fail((. Thank you for help

FIre Panda · Accepted Answer · 2011-07-05 07:01:57Z

0

In oracle you use variables like ':variableName'. This called bind variable. It improves query performance as execution plan gets reuse. So, if you use bind variables, you have to assign its value as well through you front-end code.

answered Jul 5, 2011 at 7:01

FIre Panda

6,6272 gold badges28 silver badges39 bronze badges

Collectives™ on Stack Overflow

c# insert row into Oracle table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related