Passing column names to Procedure as Parameter

[JawwadLone]

Hi everyone,
I am trying to build a dynamic query in a procedure. I want to pass the column names to the query form the front end in one parameter and table name in the second parameter field. I am writting this code

p_query varchar2 :='TEST_ID,TEST_NAME';
p_table varchar2 :='TEST'
begin
  Select "p_query" From "p_table";
end;

and receive following error

SP2-0734: unknown command beginning "p_query va..." - rest of line ignored.
SP2-0734: unknown command beginning "p_table va..." - rest of line ignored.
Select "p_query" From "p_table";
*
ERROR at line 2:
ORA-06550: line 2, column 25:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 2, column 3:
PL/SQL: SQL Statement ignored


I don't know exactly how to use these parameters in my select query.

Regards,
Jawwad Lone

 

[sem]

Your code doesn't even remind valid pl/sql code thus I suppose that it makes no sense to to talk about dynamic query.

Regards, Dima

http://seminihin.narod.ru