split should be before or after || but is splitting variable name:
should be something like:
Thanks,
Mike
Code:
DECLARE
TYPE my_rec IS RECORD(
hello_there_aaaa VARCHAR2(100),
hello_there_bbbb VARCHAR2(100));
TYPE my_tab_type IS TABLE OF my_rec;
my_tab_with_a_long_name my_tab_type := my_tab_type();
BEGIN
my_tab_with_a_long_name.EXTEND;
dbms_output.put_line(my_tab_with_a_long_name(1).hello_there_aaaa || ' ' || my_tab_with_a_long_name(1)
.hello_there_bbbb);
END;
Code:
DECLARE
TYPE my_rec IS RECORD(
hello_there_aaaa VARCHAR2(100),
hello_there_bbbb VARCHAR2(100));
TYPE my_tab_type IS TABLE OF my_rec;
my_tab_with_a_long_name my_tab_type := my_tab_type();
BEGIN
my_tab_with_a_long_name.EXTEND;
dbms_output.put_line(my_tab_with_a_long_name(1).hello_there_aaaa || ' ' ||
my_tab_with_a_long_name(1).hello_there_bbbb);
END;
Mike