Materialized View

From: ExecMan <>
Date: Wed, 16 May 2012 09:44:15 -0700 (PDT)
Message-ID: <>


Can a materialized view be created based on an object table like this. I have a PL/SQL procedure which creates this object table and populates it, then I want to create a materialized view from it:

  EXECUTE IMMEDIATE 'CREATE MATERIALIZED VIEW inst_holdings_mv AS     SELECT * FROM TABLE(CAST(v_inst_hold_rec AS inst_holdings_table))';

I get an error:

ERROR at line 1:
ORA-00904: "V_INST_HOLD_REC": invalid identifier ORA-06512: at line 44 Received on Wed May 16 2012 - 11:44:15 CDT

Original text of this message