Passing tablenamens as parameters to procedures

From: <klaus.kloeser_at_bku.db.de>
Date: Wed, 12 Aug 1998 11:05:50 GMT
Message-ID: <6qrsue$smj$1@nnrp1.dejanews.com>

Hi all,

I want to pass strings as parameters to procedures / functions, is that possible ?

With Transact SQL you can simply say EXECUTE "any sql statement" and it works, how is it done with Oracle ?

Example:

declare

v1      varchar2(20) := 'tablename';
v2	int;

begin

select count(*) into v2 from v1;

dbms_output.put_line (to_char(v2));

end;

thx in advance

Klaus Kloeser
klaus.kloeser_at_bku.db.de

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 12 1998 - 06:05:50 CDT