Re: giving field name as variable of a function

I think that you can do this kind of thing with the DBMS_SQL package. It lets you create SQL on the fly and execute it.

Tony

Diablo <diabl_at_email.com> wrote in message news:7j2r5j$hqt$1_at_usenet48.supernews.com...
> 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 - 09:10:56 CDT