Re: Materialized View
From: dombrooks <dombrooks_at_hotmail.com>
Date: Thu, 17 May 2012 12:31:29 -0700 (PDT)
Message-ID: <3299500.1171.1337283089520.JavaMail.geo-discussion-forums_at_ynss14>
Date: Thu, 17 May 2012 12:31:29 -0700 (PDT)
Message-ID: <3299500.1171.1337283089520.JavaMail.geo-discussion-forums_at_ynss14>
>
> This is all done in a PL/SQL procedure. Sorry if I did not indicate
> that before........
Well, that's obvious from the presence of EXECUTE IMMEDIATE.
As I said, prove how you're doing it with a normal table.
The points I made above still apply.
You can't pass a plsql variable to the sql engine without using a bind. You can't pass a bind to dynamic DDL, you'll get the error I mentioned. Received on Thu May 17 2012 - 14:31:29 CDT