i think it makes no difference if the record status is NEW or QUERY. if you get the message "... you can not insert records here ..." i suppose there is a other problem: check BLOCK_STATUS and FORM_STATUS
Cursors in Oracle:
A cursor is used to process individual rows returned by database system for a query.
In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…