Posted on 2004-09-27
I am receiving the below error when I try to compare collections. How to fix this one. The error is at compilation time.
v_col_AB_Info(1) := Ab_info(1,null,'ABC',1);
v_col_AB_Info(2) := Ab_info(2,1,'DEF',2);
v_col_AB_Info(3) := Ab_info(3,2,'GHIJ',3);
v_col_AB_Info_1(1) := Ab_info(1,null,'ABC',1);
v_col_AB_Info_1(2) := Ab_info(2,1,'DEF',2);
v_col_AB_Info_1(3) := Ab_info(3,2,'GHIJ',3);
IF v_col_AB_Info(1) = v_col_AB_Info_1(1) THEN
DBMS_OUTPUT.put_line('COLLECTIONS DONOT MATCH');
PLS-00526 A MAP or ORDER function is required for comparing objects in PL/SQL.
Cause: Within stand alone PL/SQL, an attempt was made to compare objects without a map or order function.
Action: Provide a map or order function and retry the operation.