You should use the sys.dbms_sql package for dynamic sql.
shailaja <saila_at_irmac.com> wrote in message
news:929477558.297.23_at_news.remarQ.com...
> I want to create a procedure which needs a input as "tablename". If i run
> that procedure and give the table name as "emp" then the procedure should
> display all the records in the emp table. This should work out for any
> table. I mean to say the moment u pass any kind of tablename as parameter
to
> the procedure the procedure should display the records for the passed
table.
> Thank u.
>
> Regards
> shailaja.
>
>
>
Received on Fri Jun 18 1999 - 18:38:08 CDT
