ORDS Query Based REST Service
Today I found one wire thing:
I am using Oracle ORDS (3.0) amd Sql*Developer(4.0) to create a get service based on an simply Sql query(cursor expression included), I following the instruction of Sql*developer but somehow the service just didn't work, keep giving "Service Denied" error.
After some digging, it turns out that there is one parameter "Pagination Size" which is having default size 25, which need to be set to 0 in order to make it work. I haven't find any reason for that yet but that's the way it is
