Newbie Dynamic SQL Question

Hello,

   I am trying to write a stored procedure that takes a user inputted tablename and dumps all the contents of the table into a flat file. Since I will be using the dbms_sql package to build my query, it seems that it is necessary to definte output variables. I am not sure how to proceed since the output variables will vary dependent on what tablename the user enters. Will I just have to write a long conditional statement that looks explicitly for what table the user enters then picks the output variables from it, or is there a sleeker, more efficient way of doing this? Any advice is greatly appreciated.

Thanks.
MM

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 14:17:04 CST