Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
All-Star
53942 Points
8147 Posts
Jul 27, 2010 04:36 AM|LINK
Go to line number 70 and see what you are passing as the parameter value.
It looks like you are not escaping single quote or having some special character in there.
if you have a single quote, replace that single quote with two single quotes in your TextBox.
txtValue.Text.Replace("'","'')
That should work I guess, but replace for string values and see if it clears the error message
sansan
All-Star
53942 Points
8147 Posts
Re: Unable to insert into oracle database - ORA-00911 error
Jul 27, 2010 04:36 AM|LINK
Go to line number 70 and see what you are passing as the parameter value.
It looks like you are not escaping single quote or having some special character in there.
if you have a single quote, replace that single quote with two single quotes in your TextBox.
txtValue.Text.Replace("'","'')
That should work I guess, but replace for string values and see if it clears the error message