Update statement not working oracle

I've tried a couple different tables and update statements do not work on either table. I'm using the Microsoft. Why are the update statements hanging using ASP. NET 2. Thank you for the suggestions.

I'm not sure what changed overnight but I came into work this morning, ran the same code, and now the update is working normally.

Toggle navigation codeverge. Update Statements Not Working. I am attempting to update an Oracle 10g table with the following code. ExecuteNonQuery When this page is submitted the update doesn't seem to complete, nothing is returned and the page never times out. Thank you. See related articles to this posting. Are you using TNS? Try this - Update DataBaseName.

Check - 1 Your column type in database is identical to the type of data you are inserting. Keep the browser going and let Oracle to return some message. Hope it helps. Similar Artilces: Multiple tables used in select statement makes my Update statement not work? I am currently having this problem with gridview and detailview.

When I drag either onto the page and set my select statement to pick from one table and then update that data through the gridview lets say , the update works perfectly. My problem is that the table I am pulling data from is mainly foreign keys. So in order to hide the number values of the foreign keys, I select the string value columns from the tables that contain the primary keys. Update statement not working First off, I'm not a database guy. I have my select statement working, but the update statement either updates every row in the table when I don't include a WHERE clause or it won't update any rows at all.

Existing Members Sign in to your account. This email is in use. Do you need your password? Submit your solution! When answering a question please: Read the question carefully. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome. Don't tell someone to read the manual. Chances are they have and don't get it.

Provide an answer or move on to the next question. Let's work to help developers, not make them feel stupid. Layout: fixed fluid. Web03 2. Strip HTML. Encode HTML. The positioned update statement depends on the cursor and any tables the cursor references.

You can compile a positioned update even if the cursor has not been opened yet. Learn more. Oracle Update statement not working correctly Ask Question. Asked 1 year, 6 months ago. Active 1 year, 6 months ago. Viewed 68 times.

EXID and t. Improve this question. Symonds Symonds 1 1 silver badge 10 10 bronze badges. Add a comment. Active Oldest Votes.