Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01425 when using § as escape character

mtramullasJan 26 2016 — edited Jan 28 2016

Hello all,

I have a problem with the escape character. We decided to use the § (ALT+0167) character as escape character in like entences. It was tested in a database with the following configuration

NLS_ISO_CURRENCYSPAINAMERICA
NLS_DATE_LANGUAGESPANISHAMERICAN
NLS_DUAL_CURRENCY€$
NLS_RDBMS_VERSION12.1.0.1.0
NLS_TIME_TZ_FORMATHH24:MI:SSXFF TZRHH.MI.SSXFF AM TZR
NLS_NCHAR_CONV_EXCPFALSEFALSEFALSE
NLS_LENGTH_SEMANTICSBYTEBYTEBYTE
NLS_TIMESTAMP_FORMATDD/MM/RR HH24:MI:SSXFFDD-MON-RR HH.MI.SSXFF AM
NLS_NCHAR_CHARACTERSETAL16UTF16
NLS_NUMERIC_CHARACTERS,..,
NLS_TIMESTAMP_TZ_FORMATDD/MM/RR HH24:MI:SSXFF TZRDD-MON-RR HH.MI.SSXFF AM TZR

and all worked fine. The problem was when it was used with a database with the following configuration

NLS_COMPBINARYBINARYBINARY
NLS_SORTSPANISHGERMAN
NLS_CALENDARGREGORIANGREGORIAN
NLS_CURRENCY€?
NLS_LANGUAGESPANISHGERMANGERMAN
NLS_TERRITORYSPAINGERMANYGERMANY
NLS_DATE_FORMATDD/MM/RRDD.MM.RR
NLS_TIME_FORMATHH24:MI:SSXFFHH24:MI:SSXFF
NLS_CHARACTERSETAL32UTF8
NLS_ISO_CURRENCYSPAINGERMANY
NLS_DATE_LANGUAGESPANISHGERMAN
NLS_DUAL_CURRENCY€?
NLS_RDBMS_VERSION12.1.0.1.0
NLS_TIME_TZ_FORMATHH24:MI:SSXFF TZRHH24:MI:SSXFF TZR
NLS_NCHAR_CONV_EXCPFALSEFALSEFALSE
NLS_LENGTH_SEMANTICSBYTECHARCHAR
NLS_TIMESTAMP_FORMATDD/MM/RR HH24:MI:SSXFFDD.MM.RR HH24:MI:SSXFF
NLS_NCHAR_CHARACTERSETUTF8
NLS_NUMERIC_CHARACTERS,.,.

In this case we obtain an exception due to the ORA-01425. I there any other way to fix this problem than change the escape character?

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2016
Added on Jan 26 2016
#database-key-features, #globalization-support
4 comments
1,819 views