Re: Materialized view dynamic row count

On Wed, 12 Oct 2005 10:27:17 +1000, Geoff Muldoon <geoff.muldoon_at_trap.gmail.com> wrote:

>connor_mcdon..._at_yahoo.com says...
>
>> execute immediate 'select count(*) from '||c.view_name
>> into l_count;
>
>D'oh me. Thanks Connor.
>
>I am in the habit whenever using execute immediate of declaring a varchar2
>named v_sql, populating the string and then calling it. Had tried:
>
>v_sql := 'select count(*) from '||c.view_name||' into '||l_count;
>execute immediate v_sql;
>
>and this was failing.
>
>Geoff M

The correct syntax is, IIRC, execute immediate into variable.

--
Sybrand Bakker, Senior Oracle DBA