I would like to execute the anonymous pl sql block and need to get the resultset object. I got the code which can be done by using cursors inside the pl sql block.
But the pl sql block itself will come from the database as text. So i cant edit that pl sql block. And it will return only two values whose column names will be same always.
Here i am giving sample pl sql block.
'select distinct fundname d, fundname r from LOVFUNDDETAILS
order by 1';
WHEN OTHERS THEN
'SELECT ''Not Available'' d, ''Not Available'' r FROM dual';
Any help will be greatly appreciated.