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;

asked 02 Dec '15, 06:09

apacheuk's gravatar image

apacheuk
139220
accept rate: 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's gravatar image

apacheuk
139220
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×16
×5
×1

Asked: 02 Dec '15, 06:09

Seen: 694 times

Last updated: 02 Dec '15, 06:16


© Copyright Gerger 2017