My Oracle Support Banner

Error searching for locations in PSR Ordering Dialog Search Locations window; java.sql.SQLSyntaxErrorException: ORA-01722: invalid number (Doc ID 1958351.1)

Last updated on MAY 10, 2022

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.


java.sql.SQLSyntaxErrorException: ORA-01722: invalid number error is thrown when attempting to search for a location in the PSR Ordering Dialog window.

NOTE: The behavior occurs when attempting a Location Search by City name without first specifying a State value.  Example; DALLAS is a valid City name for the State of Texas(TX).  Searching for City = DALLAS without State = TX results in the exception.



Image of error in GUI

Error text in GUI

5. Click the Search Now button and the exception is thrown

Business Impact

The issue can cause concern and confusion for users that encounter the  





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.