Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Count records dynamically
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.noReceived on Tue Sep 05 2000 - 07:01:01 CDT
![]() |
![]() |