Re: Can you use a Select For Update within a Explisit Cursor???

>Does anyone know if you can use an explisit cursor with forms 4.5 within
>a program unit? I need to select a set or one record first as a Query
>and if the user decides to update the value, I don't want to lock the
>record unless the user needs to update that specific record value. Any
>suggestions ?
>Thanks,
>Yakub_at_erols.com
>
>
From your question, it is not clear if you are using Oracle default locking (not explictly using a cursor), or if you are doing something else, and doing your own cursor. If you are using Oracle to execute the query and load the data, a lock is not placed on the base table until something has changed (this happens in the on-lock trigger, which fires when a CHARACTER changes, not at the field validation level). If you really want to avoid locks, put a NULL; in the on-lock trigger. As long as all access to the table is done this way, you will probably be OK, but the last one to save has their changes stick.

Dan Hekimian-Williams Received on Tue Jul 14 1998 - 07:40:15 CEST