Hi Gurus
I appreciate that if someone help me out, I have the following sample code.
Sample code
SET SERVEROUTPUT ON
DECLARE
TYPE list_of_numbers_t IS TABLE OF NUMBER;
l_numbers list_of_numbers_t :=
list_of_numbers_t (1,2,3);
BEGIN
DBMS_OUTPUT.PUT_LINE (l_numbers(1).COUNT);
END;
Error
Error report:
ORA-06550: line 7, column 38:
PLS-00487: Invalid reference to variable 'NUMBER'
ORA-06550: line 7, column 3:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
I want to refer index 1 of my collection but I'm getting the above error. Can someone help me out to remove this error. Thanks
Regards
Matt