Question:
I am trying to populate a materialized view with this code and it
fails with an ORA-00904 error:
EXECUTE IMMEDIATE ('CREATE MATERIALIZED VIEW mf_snapshot_mv AS
SELECT * FROM TABLE (CAST (v_mf_record AS mf_table_type))');
ORA-00904: "V_MF_RECORD": invalid identifier
Why cannot I use a CAST operator with an object type in a
materialized view? Isn't a PL/SQL collection array the same as a
table?
Answer:
