Re: Count records dynamically

From: deana strbevski <deana.strbevski_at_ina.hr>
Date: Wed, 06 Sep 2000 11:24:45 +0200
Message-ID: <39B60D5D.192757@ina.hr>

I think you should write a function.

Robert Vabo wrote:

> I want to count number of records in a table using a cursor so I can use it
> on any table
>
> CURSOR CountRecs (TableName VARCHAR2)
> IS
> SELECT COUNT(*) FROM TableName;
>
> When I compile this I get an error message :
>
> PLS-00356: 'TABLENAME' must name a table to which the user has access
>
> Any suggestions on another method to do this ?
>
> --
> Regards
> Robert Vabo
> Application developer
> Gecko Informasjonssystemer AS
> www.gecko.no
> robert.vabo_at_gecko.no
Received on Wed Sep 06 2000 - 04:24:45 CDT