title: How can I insert a record and lock that row simultaneously?
body: <p>I'm inserting a row using an Oracle stored procedure which is configured to use an autonomous transaction.  I'd like to insert this record, commit that transaction, and then lock the newly-inserted record so that nobody else can modify it except my current session (in another transaction, obviously, since the one that inserted it is autonomous).</p>
  
  <p>How can I ensure that nobody else gets a lock on this new record before I have a chance to <code>SELECT...FOR UPDATE</code> it?</p>
  
  <p>Using Oracle 10g.</p>