Table function - ORA-00932: inconsistent datatypes: expected - got -

Hi All,

I'm trying to return a result set of query by using table function.

The procedure I have written gets a parameter of SQL query and returns a table that contains the result set.

I have a problem when fetching the value of cursor into the table type.

The code is:

create type t_rowset_test as table of clob;

-----------------------------------------

create or replace function get_table_rows_test (f_query IN CLOB) return t_rowset_test AS

  l_rowset  t_rowset_test;

  ref_cursor_row SYS_REFCURSOR;

BEGIN

  l_rowset := t_rowset_test();

  OPEN ref_cursor_row FOR f_query;