Re: Materialized View
From: ExecMan <artmerar_at_yahoo.com>
Date: Thu, 17 May 2012 09:35:42 -0700 (PDT)
Message-ID: <85f0d8e2-ef54-48f5-b1b4-eabc61e624e6_at_t2g2000pbg.googlegroups.com>
On May 17, 10:52 am, dombrooks <dombro..._at_hotmail.com> wrote:
> Can you show the same approach working with a normal table?
>
> 1. I don't see why anyone should ever want to do this whether creating tables or MVs.
>
> 2. If this was going to work you'd need to pass a bind variable, surely. The SQL Engine knows nothing about v_inst_hold_rec.
>
> 3. You can't pass a bind variable because you'd get ORA-01027: bind variables not allowed for data definition operations.
>
> So, I'm very interested to see what you're doing when you say it works with normal tables.
Date: Thu, 17 May 2012 09:35:42 -0700 (PDT)
Message-ID: <85f0d8e2-ef54-48f5-b1b4-eabc61e624e6_at_t2g2000pbg.googlegroups.com>
On May 17, 10:52 am, dombrooks <dombro..._at_hotmail.com> wrote:
> Can you show the same approach working with a normal table?
>
> 1. I don't see why anyone should ever want to do this whether creating tables or MVs.
>
> 2. If this was going to work you'd need to pass a bind variable, surely. The SQL Engine knows nothing about v_inst_hold_rec.
>
> 3. You can't pass a bind variable because you'd get ORA-01027: bind variables not allowed for data definition operations.
>
> So, I'm very interested to see what you're doing when you say it works with normal tables.
This is all done in a PL/SQL procedure. Sorry if I did not indicate that before........ Received on Thu May 17 2012 - 11:35:42 CDT