Cleaned debug. Fixed lock handle transaction bug.

The Oracle handle allocation has an implicit commit. This obviously
affected global temporary tables that rollback on commit.
get_lock_handle placed in autonomous transaction.