Valid values to the "IN" clause of PLSQL 'sql' statements

Hi,

What are valid values to the "IN" clause of PLSQL sql statements: e.g.,
=========BEGIN PLSQL CODE SNIPPET=============== RefCursor2 := SomeOtherStoredProc;

OPEN RefCursor1 FOR
SELECT * FROM tblXYZ
WHERE colName IN RefCursor2
AND colName1 = 'xyz';

==========END PLSQL CODE SNIPPET ============ The compiler refuses to compile the statement with an 'incompatible types' error;
However, if the 'SELECT' statement that comprises 'SomeOtherStoredProc' is inserted into the 'IN' clause of the Code Snippet above, it does compile.

Any idea why this should happen? Can anybody point me to documentation that shows what types of values can be used as inputs to an 'IN' clause?

Thanks in advance.
Melroy Received on Thu Jul 31 2003 - 22:11:36 CDT