Invalid Character inserting row in Oracle C#

Question

I have a small test to insert some values in a table (Oracle) from C# the thing is that I have a sql sentence (all types are numbers except for the date):

insert into historicos values (2,1,1,to_date('01/08/2013','dd/mm/yyyy'), 0,1,25,25,36);

I've tried many forms to insert (switching commas, changing functions, etc...)

I can insert with that sql command if I paste it in the SQLDeveloper, but when I try to execute that command from C# i get an ORA-00911 Invalid character

Do you know where's the problem? Thank you so much

Twinkle · Accepted Answer · 2013-08-01 10:02:27Z

2

Do not forgot removing " ; " at end of the query...

answered Aug 1, 2013 at 10:02

Twinkle

1165 bronze badges

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

Collectives™ on Stack Overflow

Invalid Character inserting row in Oracle C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related