Last post Nov 26, 2018 09:37 AM by PatriceSc
Nov 23, 2018 09:52 AM|shsu|LINK
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
Nov 23, 2018 12:51 PM|PatriceSc|LINK
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).
Nov 23, 2018 03:41 PM|raghav_khunger|LINK
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?
Nov 24, 2018 01:38 AM|shsu|LINK
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
Nov 26, 2018 09:37 AM|PatriceSc|LINK
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.