How to get all the rows from Custom Query Webservice (Doc ID 968055.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Utilities Meter Data Management - Version: 04.53.00.04.00 - Release: 4.5
Information in this document applies to any platform.

Goal

When web service is called which in turn calls Business rule of type Custom Query then the query defined in procedures.*.xsl file is executed. This file is located either in \lodestar\bin folder or in \lodestar\cfg folder.
By default this query returns only 100 rows which are then passed as web service response. This document give details on how to modify the default settings so as to get all the rows returned by the particular query.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms