using tt_requiredcolumnviolation in anger

Question

I'm trying to loop through a list of records in a grid that have missing mandatory columns, so I'm using api_datasource.getrequiredcolumnviolations however I get an error

Error(2078,22): PLS-00224: object 'ERROR_ROWS_T(I)' must be of type function or array to be used this way

I'm pretty certain my code is correct, maybe I'm missing something

PROCEDURE rra_as_OK IS

error_rows_t api_datasource.tt_requiredcolumnviolation; v_err_rowid NUMBER;

BEGIN

error_rows_t := api_datasource.getrequiredcolumnviolations('V_RRA_AS_RMD1');

FOR i IN 1..error_rows_t.COUNT LOOP
  v_err_rowid := error_rows_t(i)('ROW_ID').value_nr;
  api_debug.log('v_err_rowid: '||v_err_rowid);
END LOOP;

Answer 1

0	figured it out.... :) needed to change `v_err_rowid := error_rows_t(i)('ROW_ID').value_nr;` to be `v_err_rowid := error_rows_t(i).ROW_ID;` odd that it works differently to the others such as `tt_rows` link answered 02 Dec '15, 06:16 apacheuk 139●1●8●46 accept rate: 0%

using tt_requiredcolumnviolation in anger

Follow this question

Related questions