how to determine a value in a PL/Sql table for testing
Posted on 2014-10-02
I'm testing some logic that populates this PL/Sql table, but I'm having trouble seeing the values when debugging.
TYPE varchar2_tabtype IS
TABLE OF VARCHAR2(20)
INDEX BY BINARY_INTEGER;
The procedure that uses this populates the table and passes it back
(,P_MEETING_TIME_IN IN VARCHAR2
,P_DAY_OF_WEEK IN CHAR
,P_TABLE_IN_OUT IN OUT VARCHAR2_TABTYPE
In one section of code, it's populated like this:
p_table_in_out(i) := v_end_position;
and I can see the value in debugging, made sense to me.
But in another section of code, it's populated like this:
p_table_in_out(v_count_table_rows) := 10;
and when I hover over this while debugging, it says "Not a variable" . . .
but it looks like it's doing the same thing, just a different counter for the PL/Sql table, "i" vs "v_count_table_rows"
perplexing . . .