Re: locking a row

You need to write in your message the sql/forms etc that you are using.

People cannot guess what you are doing. Often syntax is the issue not the process.

In general, it is not likely that you should ever need to explicitly lock a record in Oracle.
Let the engine do it. If you need a transaction block with rollback capabilities, add
that to your code.

Mike Krolewski

Prashant.r.joshi_at_usa.net wrote:

> hi,
>
> i am having a problem in locking a record oracle gives it's on altert in
> place of that i want my own one i have tried to do it through on-error and
> on-message if someone gives me some idea. pl. if anyone knows about it
>
> my e-mail address is Prashant.r.joshi_at_usa.net
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Aug 30 1998 - 23:16:21 CEST