It can be done with Oracle but not with the built-in locks. Oracle>Hi,
>i want to lock an defined area of records in a table (e.g. all records
>to a defined date). No other application should access this record and
>no insert with this date should be possible. As far as I know it is
>not possible to achive this with the possibilities a database (DB2 /
>Oracle) gives me (select/fetch for update or lock table,..). So I
>think I have to lock the records logical. Me idea was to write a
>record in a kind of "lock table".
>But now I have the problem that if the application will crash, the
>record in the lock table is still there (my application commits after
>every record and I can't change this !).
>Thank you for helpful ideas !!!
supplies the DBMS_LOCKS package so that developers can create their own
in situations such as this. I can't recall but I would think DB2 must
also have a similar ability.
(replace 'x' with a 'u' to reply)