The following Built-in subprograms cannot be called from a trigger while Oracle Forms is in Enter Query mode:
ABORT_QUERY |
LAST_RECORD |
CALL_INPUT |
LOCK_RECORD |
CLEAR_BLOCK |
LOGON/LOGON_SCREEN/LOGOUT |
CLEAR_FORM |
NEW_FORM |
COMMIT_FORM |
NEXT_BLOCK |
CREATE_QUERIED_RECORD |
NEXT_RECORD |
CREATE_RECORD |
NEXT_SET |
DELETE_RECORD |
POST |
DOWN |
PREVIOUS_BLOCK |
DUPLICATE_RECORD |
PREVIOUS_RECORD |
FETCH_RECORDS |
SCROLL_DOWN |
FIRST_RECORD |
SCROLL_UP |
GO_BLOCK |
SELECT_RECORDS |
GO_RECORD |
UP |
INSERT_RECORD |
UPDATE_RECORD |
Note: Because Oracle Forms prevents navigation out of the current block while in Enter Query mode, GO_ITEM is allowed only if the target item is in the current block.
Fire in Enter-Query Mode Property
Creating a trigger that fires in Enter Query mode