Re: table name

Well, if you run this

create or replace procedure seltest (tablename in varchar2) as
begin
select * from tablename;
commit;
end;

you will see that it does not use the parameter. Any ideas?

G Quesnel wrote:
> A table name is no different than any other character string value.
> You should be able to declare the variable as a varchar2(30).
> You will probably also want to include the schema name as another
> variable.
> If you want more help, please post the Oracle version you intend to
> use.
> For example, your approach using Oracle 10g, could be to use the
> datapump API procedures.
>
> HTH
Received on Wed Aug 02 2006 - 13:55:10 CDT