Pular para o conteúdo principal

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.