sql - How can I insert a record and lock that row simultaneously? -

I am putting a line using an Oracle stored procedure that is configured to use an autonomous transaction . I would like to incorporate this record, to do that transaction, and then lock the newly inserted record so that no one can modify it except by my existing session (in the second transaction, obviously, it contained it He is autonomous). / P>

How can I ensure that I have the chance to update SELECT ... before before anyone is locked on this new record ?

Using Oracle 10G

No, you can maintain a lock between transactions. You should ask yourself the question of why you need to issue a commitment between insert and ... for update ... enter the line is locked by; If you are doing it with that line before completing it, then you do not have to worry about locking again.