Kbase P187167: Getting ora-01425 error when performing a SQL statement that contains and escape statement in the WH
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/4/2011 |
|
Status: Unverified
SYMPTOM(s):
Getting ora-01425 error when performing a SQL statement that contains and escape statement in the WHERE clause when Oracle database is on specific Unix system.
Getting same error using SQLPLUS to Oracle when Oracle Database is on specific Unix system.
Problem does not occur to all Oracle databases on Unix.
Probelm does not occur to Oracle database on Windows.
Example of Select statement:
SELECT from FROM customer WHERE Name LIKE upper('test') ESCAPE '\')
FACT(s) (Environment):
Oracle DataServer
OpenEdge 10.2B
UNIX
CAUSE:
The exact cause is unknown at the time of the writing
FIX:
The suspicion is that this is an Oracle database configuration problem.
Contact Oracle Technical Support to seek a resolution.