PL/SQL tablename as variable

hello!

the following statement compilation fails within a stored procedure in a package (Oracle Version 7.3.4.1):

insert into table_name (select * from table_name_2);

table_name and table_name_2 are variables. Oracle does not accept the statement with the following error message:

PLS-00356: 'TABLE_NAME' must name a table to which the user has access

how can I fix the problem. i do need the dynamic way of assigning a value to table_name!

regards

   thomas Received on Wed Nov 28 2001 - 09:27:24 CST