PL/SQL

Hi,

I am trying to access a table within a oracle function. The function looks similar to:

The function get an id as argument it then select in one main table (elements) the tablename where to look for an specific attribute in the detail table (v_class).
While compiling the function oracle tells me that v_class is no table.
Hints ver welcome !!
Thanks.

create or replace function get_ident
(v_comp_elid in varchar2)
RETURN number
is

   v_ident number;
   v_class varchar2(20);
begin
--

• Select tablename from elements
  --
  select e.tablename into v_class from elements e where e.elid=v_comp_elid;
  --
  
• Now select ident from table
  --
  select ident into v_ident from v_class where elid=v_comp_elid;
  --
  --
  RETURN (v_ident); end get_ident; / show errors /

LINE/COL ERROR
-------- -----------------------------------------------------------------

20/2     PL/SQL: SQL Statement ignored
23/3     PLS-00356: 'V_CLASS' must name a table to which the user has
         access