Oracle Forms (MOSC)

MOSC Banner

ORA-12713 character data loss in NCHAR/CHAR conversion

edited Jan 13, 2020 3:06PM in Oracle Forms (MOSC) 1 commentAnswered ✓

Hello,

We recently migrated from Wintel 2008 R2/Oracle Forms 11gR2 to Linux RHEL6/Oracle Forms 12c (12.2.1.3.0)

In Linux we are encountering the error: ORA-12713 character data loss in NCHAR/CHAR conversion.

I have isolated the problem to the users entering the section sign (double S) into free form fields.

When queried from the database into a base table field it renders as ?

When the same field is retrieved via a database package procedure into a form field the ORA-12713 error occurs.

If the same DB procedure is executed in SQL*PLUS, the data renders as a small circle with an underscore underneath it. Sorry, I cannot find Unicode character or symbol on-line.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center