My Oracle Support Banner

ServiceLayer Reports 'Only SELECT Statements Are Supported' During Query POST Methods (Doc ID 2675312.1)

Last updated on MAY 29, 2020

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.2.0.13 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.13 version, General

ACTUAL BEHAVIOR
---------------
Create a query in ServiceLayer: Select taxid, taxidtype, alternatename2 from oipa_user.asclient
After executing the query, it fails with message":"Only Select statements are supported."


EXPECTED BEHAVIOR
-----------------------
ServiceLayer should return the query results from OIPA.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create this query in ServiceLayer using /PASService/rest/services/queries/:

Select taxid, taxidtype, alternatename2 from oipa_user.asclient


POST /PASService/rest/services/queries/testClientNew

{"applicationName":"testClientNew","queries":[{"queryName":"testClientNew","queryValue":"Select taxid, taxidtype, alternatename2 from oipa_user.asclient"}]}


2. Execute it using /PASService/rest/services/queries/<query_name>

GET PASService/rest/services/queries/testClientNew?applicationName=testClientNew

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.