Hello All,

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.

BEGIN

RETURN

'select distinct fundname d, fundname r from LOVFUNDDETAILS

where condition

order by 1';

EXCEPTION

WHEN OTHERS THEN

RETURN

'SELECT ''Not Available'' d, ''Not Available'' r FROM dual';

END;

Any help will be greatly appreciated.

Regards,

Raj