Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Count records dynamically

Count records dynamically

From: Robert Vabo <robert.vabo_at_gecko.no>
Date: Tue, 05 Sep 2000 12:01:01 GMT
Message-ID: <1g5t5.808$N4.283106@juliett.dax.net>

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 Tue Sep 05 2000 - 07:01:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US