Invalid reference to Oracle Forms object
In Oracle Forms, many procedures and functions need a reference to an object (blocks, itens, alerts...). Unfortunately, the only way to pass a reference to an object is using a VARCHAR2 variable and these references are not checked by the compiler.
Currently this rule checks the following methods:
Alert builtins:
- FIND_ALERT
- SET_ALERT_BUTTON_PROPERTY
- SET_ALERT_PROPERTY
- SHOW_ALERT
Block builtins:
- FIND_BLOCK
- GET_BLOCK_PROPERTY
- GO_BLOCK
- SET_BLOCK_PROPERTY
Item builtins:
- CHECKBOX_CHECKED
- CONVERT_OTHER_VALUE
- DISPLAY_ITEM
- FIND_ITEM
- GET_ITEM_INSTANCE_PROPERTY
- GET_ITEM_PROPERTY
- GET_RADIO_BUTTON_PROPERTY
- GO_ITEM
- IMAGE_SCROLL
- IMAGE_ZOOM
- PLAY_SOUND
- READ_IMAGE_FILE
- READ_SOUND_FILE
- RECALCULATE
- SET_ITEM_INSTANCE_PROPERTY
- SET_ITEM_PROPERTY
- SET_RADIO_BUTTON_PROPERTY
- WRITE_IMAGE_FILE
- WRITE_SOUND_FILE
LOV builtins:
- FIND_LOV
- GET_LOV_PROPERTY
- SET_LOV_COLUMN_PROPERTY
- SET_LOV_PROPERTY
- SHOW_LOV
Note: this rule is automatically disabled when the project's sonar.plsql.forms.metadata
is not specified.