Re: Materialized View

From: ddf <oratune_at_msn.com>
Date: Wed, 16 May 2012 13:28:48 -0700 (PDT)
Message-ID: <58fd1597-3229-44a4-80a5-22d460aa37c4_at_r4g2000pbf.googlegroups.com>

On May 16, 10:44 am, ExecMan <artme..._at_yahoo.com> wrote:
> Hi,
>
> 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

v_inst_hold_rec is out of scope for the execute immediate command.

David Fitzjarrell Received on Wed May 16 2012 - 15:28:48 CDT