4.2.4 Exception Messages

The Product to Instrument Mapping function may cause two exceptions to appear. The text and explanation for each of these exceptions follows. If you call the function from a PL/SQL block you may want to handle them so that your program can proceed.

• Exception 1: Table does not exist

  The exception message reads:

  Table 'TABLE_NAME' does not exist.

  This exception occurs when the function does not find the Instrument table.

• Exception 2: Column does not exist

  The exception message reads:

  Column 'Column_Name' does not exists in the instrument table 'Table_Name' while processing dimension 'Dimension ID'.

  This error occurs when leaf column does not exist in the Instrument table.