Unanswered: Oracle 10g - Comparing Collection using = operator
I am into an unusual sort of problem. Oracle 10g, very clearly says that one can compare two collections (Associative Arrays or Nested tables) using the = operator. I in fact tried one of the examples put at the oracle site (http://www.oracle.com/technology/ora.../o53plsql.html) and it is not getting even compiled saying the same age old prpblem - PLS-00306: wrong number or types of arguments in call to '='.
My Procedure looks like this :
CREATE OR REPLACE PROCEDURE COLL_TEST AS
TYPE table1_tt IS TABLE OF test1%ROWTYPE;
nt_copy1 := nt_copy1;
nt_copy2 := nt_copy1;
BULK COLLECT INTO nt_copy1
BULK COLLECT INTO nt_copy2
IF nt_copy1 = nt_copy2 then
DBMS_OUTPUT.PUT_LINE('WE ARE EQUAL:: TOOK TIME:::'||DBMS_UTILITY.GET_TIME());
test1 stands a valid table in my schema.
Can anyone please elaborate and throw some light, so as to why this problem.
Ur replies are appreciated.