Unanswered: PLS-00382: expression is of wrong type
TYPE test_type IS REF CURSOR RETURN TestTable%ROWTYPE;
OPEN cur_test FOR SELECT col1, col2, col3 FROM TestTable;
In a procedure i tried to open a ref cursor, and ended up with this error..
PLS-00382: expression is of wrong type
the problem here is i have not used all the columns of TestTable in my cursor declaration as defined in the TYPE definition of test_type. My test table has some more columns (say col4 and col5), this is my guess,..
i would like to know, does the above error (PLS-00382) occurs due to any other reasons failing my guess,...