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_at_juliett.dax.net>
Date: Tue, 05 Sep 2000 12:01:01 GMT
Message-ID: <1g5t5.808$N4.283106_at_juliett.dax.net>
[Quoted] [Quoted] I want to count number of records in a table using a cursor so I can use it [Quoted] on any table
CURSOR CountRecs (TableName VARCHAR2)
IS
[Quoted] SELECT COUNT(*) FROM TableName;
[Quoted] 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 [Quoted] Application developer Gecko Informasjonssystemer AS www.gecko.no robert.vabo_at_gecko.noReceived on Tue Sep 05 2000 - 14:01:01 CEST