Thanks for your response. Please download the latest package now. I have tested with the following sqls:
delete from numbers where num > 2 ;
delete from numbers where deleted() ;
select * from numbers;
BTW, "pack table numbers;" is preferable to pack empty rows.
If you still meet timeout exception, you should check whether an open ResultSet object is holding that table, because pack table will use table exclusively.
|