Re: Materialized View
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Fri, 18 May 2012 14:14:38 +0200
Message-ID: <4fb63d29$0$3115$ba620e4c_at_news.skynet.be>
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
Date: Fri, 18 May 2012 14:14:38 +0200
Message-ID: <4fb63d29$0$3115$ba620e4c_at_news.skynet.be>
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
You're wasting your precious breath, David, if the man doesn't realize he's switching from PL/SQL to SQL when calling "execute immediate" ... Received on Fri May 18 2012 - 07:14:38 CDT