Dynamic replacement of Column Name in a Procedure

[maitrasuman]

Pl. help me to resolve this problem :-

In a stored procedure I want to pass a parameter which will substitute the column_name of a particular table for query purpose, say as for example

SELECT EMPNAME FROM paymain A
WHERE A.v_colname = '08262755' -- here v_colname is the

parameter which I want to put. Is it possible to write a query like this or there are other way rounds. I do not want to hardcode the column name of the queried table.

 

[lewisp]

Use a refernce cursor or dynamic SQL.