-
Ora-22926
We recently upgraded to 10g (using Oracle version 10.2.0.3.0).
The problem is that we're trying to enter multi-byte characters (Chinese characters) into our TGRAMS application. However, when we try to save
that text in the application, we get an "v_alltxtmstr" error (which is, according to one of our DBAs, an ora-22926 error). The changes then roll
back.
We know that the data fields in our TGRAMS application can handle the double-byte data because we've never had this problem before.
This error seemed to occur after we upgraded to 10g.
Our application is located on a PC that has a Chinese Operating Systerm (XP) and Office 2003 (Chinese). We copy and paste the Chinese text from a Word doc into the application.
We tried typing the text as well as pasting the document into word pad first before inserting it into the application.
So, we are at a lost. Any help you could provide would be appreciated.
-
ORA-22926 is related to LOB data type; are you trying to store your chinese chars into a LOB column?
> oerr ORA 22926
22926, 00000, "specified trim length is greater than current LOB value's length"
// *Cause: The input length for which to trim the LOB value to is greater
// than the current length of the LOB value.
// *Action: May not need to trim the LOB value because it's already smaller
// than the trim length specified. Or, if trimming the LOB value
// really is required, use a smaller trim length.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Yes, we're trying to store the text in a character LOB column. But, I don't understand why we would get that error. I have to confirm this, but the LOB value is 2G. Surely, that's enough to hold the characters??
-
Look for dbms_lob.trim in your code.
As per Oracle documentation "Action: May not need to trim the LOB value because it's already smaller than the trim length specified. Or, if trimming the LOB value really is required, use a smaller trim length"
You might want to do it in your Test/UAT environment.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Thank you. I appreciate your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|