I am running a delete(to wipe out current data in database table) and then doing an insert all in the same asp page and then receiving
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation
Here is what I tried to do to troubleshoot. Unchecked enable query timeout on oracle odbc, added a <% Server.ScriptTimeOut = 900 %> to my page but these did not make any difference.
What did work was if I commented out my insert statement and just left my
delete from table x
it worked. Also note that I tried to delete the majority of the records in the database because I thought it may have an issue with it being too full. So now I am left with 82 records and it is still not working. Any ideas?