giving field name as variable of a function

I need to write a function that takes a field name as variable like this:

Function F_PUR_F05
  ( FieldName IN VARCHAR2)

cursor C_PER is

    SELECT * FROM sometable
    WHERE FieldName ='XXXX';
.......

But I could not do it as it does not recognize varchar2 as a fieldname.. Any ideas?

Any help would be appreciated. Received on Wed Jun 02 1999 - 03:51:48 CDT