What is a static cursor?
A static cursor supports scrolling forward and backward thru the data, thus allowing random access to the data. This cursor type provides a “snapshot” of the result of your query – records modified, added to, or removed from the database after the cursor is populated will not be visible. A server side static cursor can place considerable strain on the database system. A client-side cursor is always static. If an analysis or other usage of the IDP requires random access or multiple passes thru the data, this type of cursor may be needed.
