Re: Materialized View
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 17 May 2012 20:04:21 +0000 (UTC)
Message-ID: <jp3lk5$e6l$1_at_solani.org>
On Thu, 17 May 2012 12:48:52 -0700, ddf wrote:
>
> 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
Date: Thu, 17 May 2012 20:04:21 +0000 (UTC)
Message-ID: <jp3lk5$e6l$1_at_solani.org>
On Thu, 17 May 2012 12:48:52 -0700, ddf wrote:
> On May 17, 10:52 am, Mladen Gogala <gogala.mla..._at_gmail.com> 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? >> >> --http://mgogala.byethost5.com
>
> 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.
-- http://mgogala.byethost5.comReceived on Thu May 17 2012 - 15:04:21 CDT