Re: Row-Count in PL/SQL

Rene Nyffenegger wrote:
>>Hi,
>>
>>IŽd like to count table-rows in PL/SQL.
>>The tablename comes from a variable. Something like:
>>
>>SELECT COUNT(*) INTO V_ROWS
>>FROM V_TABLE_NAME;
>>
>>I still get the same error message:
>>"V_TABLE_NAME must be declared"
>>
>>But V_TABLE_NAME is declared in my
>>CURSOR-SELECT-Statement.
>>
>>Thanks for all suggestions.
>>
>>O.Braun

> 
> 
> This could be a typical ORA-00942 error.
> 
> If this is the case, check 
> http://www.adp-gmbh.ch/ora/err/ora_00942.html
> 
> 
> hth
> Rene

Typical is correct. It can not be done except with dynamic SQL.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)