Re: Materialized View

From: Mladen Gogala <>
Date: Thu, 17 May 2012 20:04:21 +0000 (UTC)
Message-ID: <jp3lk5$e6l$>

On Thu, 17 May 2012 12:48:52 -0700, ddf wrote:

> On May 17, 10:52 am, Mladen Gogala <> wrote:

>> On Thu, 17 May 2012 09:35:42 -0700, ExecMan wrote:
>> > This is all done in a PL/SQL procedure.  Sorry if I did not indicate
>> > that before........
>> You're creating a materialized view in a PL/SQL procedure?
>> --

> Using EXECUTE IMMEDATE. The PL/SQL variable you are trying to pass in
> the execute immediate text does not exist in the SQL context you create
> with the execute immediate call -- thus it's out of scope for SQL as it
> has no idea what you are referring to. It's basically the same talking
> on the telephone to someone across town and saying 'Did you see that?'
> while looking at an event outside of your window; the person across town
> doesn't have your viewpoint and can't relate to the question or the
> subject of it.
> David Fitzjarrell

This looks like one of those "object factory" philosophical things. That reminds me why I do not adopt programming paradigms in place of religions. There is but one God and Tom Kyte is his prophet.

Received on Thu May 17 2012 - 15:04:21 CDT

Original text of this message