On Mon, 2003-03-24 at 22:50, Hiroshi Inoue wrote:
> Does the SQL standard allow INSENSITIVE updatable cursors ?
Hmmm... apparently not:
(Subsection 14.1, Syntax Rules of DECLARE CURSOR)
11) If an <updatability clause> of FOR UPDATE with or without a <column
name list> is specified, then INSENSITIVE shall not be specified and QE
shall be updateable.
I'm not really sure I see the point of this restriction, though...
Cheers,
Neil