locked
Grid view autogenerate- is delaying for long time-VB.NET RRS feed

  • Question

  • User-1578974752 posted

    I have placed delete query inside the gridview (auto generate  delete ).Connected to Oracle 

    DELETE FROM ZZZTEC_SSS_INCIDENT_REP WHERE (LINE_NUMBER = :LINE_NUMBER) 

    first few deletion is working fine then it is keep on delaying. how to solve that. Thanks

    Friday, November 23, 2018 9:52 AM

Answers

  • User753101303 posted

    Seems a lock (at the database level ?). Not 100% sure if you mean the server side code stops at this statement. If you mean it doesn't do anything it could be the key is not correct.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, November 26, 2018 9:37 AM

All replies

  • User753101303 posted

    Hi,

    It "hangs" ? Could it be a locking issue ? I'm not using Oracle but try perhaps https://dba.stackexchange.com/questions/86579/how-to-find-out-who-is-active-and-locking-the-oracle-database

    IMO it's often quicker to spend few extra minutes to make 100% sure about what happens. Else you have to guess about what really happens and it is usually longer to guess right (and worse if running into an unusual error).

    Friday, November 23, 2018 12:51 PM
  • User1281381861 posted

    Try to find sp_who2 of SQL equivalent in Oracle. That should give you some pointers for lock.

    Can you correct the spellings too in your title?

    Friday, November 23, 2018 3:41 PM
  • User-1578974752 posted

    Yes,it is hanging ,Then I close it and reopen again.No error message

    First few,no issue..it is deleting at that moment itself..Thanks

    Saturday, November 24, 2018 1:38 AM
  • User753101303 posted

    Seems a lock (at the database level ?). Not 100% sure if you mean the server side code stops at this statement. If you mean it doesn't do anything it could be the key is not correct.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, November 26, 2018 9:37 AM