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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.