hi all,
i would like to have a function with two parameters.one is coloumn name and another one is table. using that table name i have to fetch the multiple records into the cursor which is dynamic, how can i do that. plz reply me if u know.
thanks&regards,
kiran kumar jonnalagadda
india

Hi Uskiranj,

What i understand from the problem is that you have to pass the table name and column to the sql query which will accordingly return you the recordset...
Now in order to implement this i guess you need to have a dynamic sql and also a dynamic cursor...since the number of records returned are more than one i guess it is better to use the oracle supplied package DBMS_SQL for building up and executing your sql query...

If you need some help with the DBMS_SQL package use the follwing link
http://download-west.oracle.com/docs...sql.htm#998120


reagrding the dynamic cursor you can use Ref Cursor..for more info
http://download-west.oracle.com/docs...5_ora.htm#1554