table operator on table of rowids

Is it possible to use the table operator on a PL/SQL table containing rowids?

As far as I can tell, the table operator can only be used on schema-level table types, not table types declared in PL/SQL. Schema table types are not allowed to be 'table of rowid' and schema level object types - of which I could create a table - are not allowed to have attributes of type rowid.

What I'm trying to achieve is something like the following without having to use dynamic SQL to create the in list.

OPEN my_ref_cursor FOR
SELECT *
FROM some_table
WHERE rowid IN (SELECT * from TABLE(CAST(plsql_table AS rowid_table)));

TIA
Chris Received on Fri Jan 30 2004 - 08:11:10 CST