Passing Table name as an argument

From: <vragha_at_my-dejanews.com>
Date: Wed, 14 Apr 1999 00:45:57 GMT
Message-ID: <7f0og3$1kd$1@nnrp1.dejanews.com>

Hello!

I want to pass a table name as an argument to a stored procedure? Is it possible at all or am I dreaming?

Iwas trying it with a very simple stored procedure e.g

#######################PL/SQL script#####################################
create or replace procedure sp_test(table_name in varchar2(100)) is

        test_num   number;
        selecttable varchar2(100);

begin

select count(*) into test_num from table_name; end;
#######################End PL/SQL script#####################################

I tried out various combinations using this, but without luck. Can anybody suggest how to go about this.

Thanks.

--
Vijay R
vragha_at_my-dejanews.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 13 1999 - 19:45:57 CDT