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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Count records dynamically

Re: Count records dynamically

From: <maarten.scharroo_at_wkap.nl>
Date: Tue, 5 Sep 2000 14:44:32 +0200
Message-ID: <8p2prp$r01$1@nereid.worldonline.nl>

Robert,

Use the DBMS_SQL package to execute dynamic SQL. Look at http://technet.oracle.com for documentation on the DBMS_SQL package.

Maarten,

"Robert Vabo" <robert.vabo_at_gecko.no> wrote in message news:1g5t5.808$N4.283106_at_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:44:32 CDT

Original text of this message

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