Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Posts
    140

    Angry Unanswered: Need help ASP Delete not working

    Hello again,

    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

    Code:
    Error Type:
    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
    Code:
    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?

  2. #2
    Join Date
    Aug 2006
    Location
    San Francisco, CA
    Posts
    136
    Two things:

    1. If the insert statement is giving you the error, please post the insert statement so that we can look at it

    2. delete from table x - will delete all the rows in the table, you should probably add a where clause

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •