I am trying to pass the table name dynamicaly to the query and want to fetch the records.
I went through the forum database and got this solution
You cannot use tablenames as variables in cursors. In 8.1.6 you can use cursor variables with dynamic select statements.
type refcur_ty is ref cursor;
tablename := 'EMP';
open refcur for 'select * from '||tablename;
fetch refcur into emprec;
This solution is working but outputs only the first record, the other records are not display, could you help me.