My Oracle Support Banner

Search Query Fails If Parameters Are In Different Order With Error: Unable To Retrieve Search Results. Invalid Characters In The Number 'This_Number'. Runtime Error: Java.Lang.NumberFormatException: For Input String: "This_Number" (Doc ID 1487180.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

Oracle WebCenter Content - Version to [Release 11g]
Information in this document applies to any platform.


Given an 11g environment as follows: UCM with the May opatch, or via the Configuration page: 11gR1- (Build:

if you have an integer metadata field, say xMyIntField, and a Security Group, say These_Groups

The following queryText fails to execute:

xMyIntField > `1234` dSecurityGroup `These_Groups`

...with the error:

Unable to retrieve search results. Invalid characters in the number 'These_Groups'. Runtime error: java.lang.NumberFormatException: For input string: "These_Groups"

However, simply swapping the two expressions the following query works fine in the same environment :

dSecurityGroup `These_Groups` xMyIntField > `1234`


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

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