Dynamic sql ref cursor was the only way to have some personal query validations . Every time we cannot create data model reports etc to run some small validation query . Its a great problem unless we get some alternative like sql developer .