Re: Nested tables, Instead Of triggers, Cast and Multiset, with PLS-00201 error

From: Ed prochak <>
Date: 26 Mar 2004 11:49:35 -0800
Message-ID: <> (K Brown) wrote in message news:<>...
> I am hoping that someone out there has some experience with INSTEAD OF
> triggers, nested-table inserts, and CAST expression using MULTISET.
> I have a situation where I need to move data from one table with
> nested tables in a development schema to an exact replica of the table
> with nested tables in a production schema. I am hoping to use our ETL
> tool (Informatica) to manage this process, however, the ETL tool does
> not support inserts or updates into nested tables. To work around
> this issue I have created a "De-Nested" view of the nested table with
> the ETL tool inserting the data into the view. To do this, I need an
> Thanks!
> K Brown

Why go thru all this work? You said the production table was "an exact replica" of the developmental one, so just do an export and an import. Have you tried that?

 ed Received on Fri Mar 26 2004 - 20:49:35 CET

Original text of this message