Cursor-Locking Options

Specifying the holdlock or shared options (of the select statement) when you define an updatable cursor have certain effects.