plsql - Oracle pipelined table and Materialzed View -

i have type defined in oracle, have function returns collection of type. like:

type:

create or replace type mildap object (then type definition here) 

the collection:

create or replace type mildaps table of mildap; 

the function:

function f_testquery return mildaps (function work here populate mildaps) 

when execute sql query return mildap results expected. looks this:

select * table(f_testquery) 

due work function doing runs pretty slow, wanting materialize it...like so:

create materialized view wevldap_mv refresh complete on demand start to_date('29-04-2015', 'dd-mm-yyyy') next trunc(sysdate +1)  select * table(f_testquery); 

but ora-06502 numeric or value error.

is possible materialize in way?...any ideas?

please try this.

 create materialized view wevldap_mv refresh complete on demand start to_date('29-04-2015', 'dd-mm-yyyy') next to_date(sysdate, 'dd-mm-yyyy')+1 select * table(f_testquery);

regards.