Help on PL/SQL

Hi,

I have a question to ask:

I need to create a stored procedure which contains a string type parameter, say

    CREATE OR REPLACE proc_1(fieldname CHAR)     ....

Now, suppose the actual parameter I am passing is a field name in a table, my question is How I am able to run a SQL statement, something like this:

    SELECT "fieldname" from table1;

Is there any way to do this? Any input is highly appreciated.

Thanks.

BC Received on Fri Mar 21 1997 - 00:00:00 CST