Sitemap

Amicuk Programming Answers

ORA-22926: specified trim length is greater than current LOB value's length

-0001-11-30   Views:32

Advertisement

I am getting an ORA-22926 when passing a clob to the REPLACE function in 11gR2. I found this comment from someone else who experienced this: 1. Identified the issue as the replace function that works on Oracle 10gR2, but not on 11g for the CLOB of so

I am getting an ORA-22926 when passing a clob to the REPLACE function in 11gR2. I found this comment from someone else who experienced this:
1. Identified the issue as the replace function that works on Oracle 10gR2, but not on 11g for the CLOB of some
of the xml files for some character setting in the Oracle database.
2. Submitted a service ticket to Oracle.
3. Oracle provided a workaround solution.
4. Implemented the Oracle workaround solution.
Here is the link:
http://www.alfred.edu/banner/docs/general84S1_release.pdf
Does anyone know the workaround for this?
Thanks

The replay answer
Advertisement
I found a work around for this issue. REGEXP_REPLACE works as it should for clobs in 11g, so if you get ORA-22926 using the REPLACE function, try using REGEXP_REPLACE.

Go to See the other 2 answers

ORA-22926: specified trim length is greater than current LOB value's length

Category:DefaultRelease time:-0001-11-30Views:130

I am getting an ORA-22926 when passing a clob to the REPLACE function in 11gR2. I found this comment from someone else who experienced this: 1. Identified the issue as the replace function that works on Oracle 10gR2, but not on 11g for the CLOB of so[More]

Trim on a clob returns ORA-22926 if the clob is the result of getClobVal()

Category:DefaultRelease time:-0001-11-30Views:130

I tried to trim whitespace from a CLOB, and got an ORA-22926 exception, which is strange since I did not supply a trim length. I eventually noticed that it only occurs when the CLOB is the result of the getClobVal method. The following code triggers[More]

ORA-22926 Error

Category:DefaultRelease time:-0001-11-30Views:130

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 or ad data in the application, we[More]

ORA-01741: illegal zero-length identifier

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends, I am facing a weird situation while creating a report with region having type as SQL Query(PL/SQL function body returning SQL Query). I have a package function which takes 4 parameters and returns a SQL query in a varchar2 variable. Now w[More]

[b]ORA-01450: maximum key length exceeded[/b]

Category:DefaultRelease time:-0001-11-30Views:130

Hi I get this error when trying to migrate MS Access 2000 to Oracle. I get this error on foreign key and primary keys saying that the maximum key length has been exceeded. What does this mean and how can I fix it? Can anyone help? Thanks RayMaximum k[More]

ORA-28232: invalid input length for obfuscation toolkit

Category:DefaultRelease time:-0001-11-30Views:130

hi, i am facing this error when i enterd more then 8 charecter in the input string. ORA-28232: invalid input length for obfuscation toolkit why i cant user more then 8 charecter for password.?Rajnish Chauhan wrote: hi, i am facing this error when i e[More]

ORA-01450: maximum key length (string) exceeded

Category:DefaultRelease time:-0001-11-30Views:130

CREATE TABLE ABC (ADAPTERINSTID NUMBER(12), MOTYPEID NUMBER(12), GROUPDISCID VARCHAR(3000), MEMBER_MOTYPEID NUMBER(12), MEMBER_MOINSTID VARCHAR(3000), primary key ( ADAPTERINSTID, MOTYPEID, GROUPDISCID, MEMBER_MOTYPEID, MEMBER_MOINSTID)); This is Ora[More]

ORA 01450 : maximum key length (1942) exceeded

Category:DefaultRelease time:-0001-11-30Views:130

hI all, i got that message when try to create index. ORA 01450 : maximum key length (1942) exceeded Regards,Maximum key length also depends on tablespace block size. It seems that your value (1942) may be for 2K blocks. At least for my 10.2.0.1.0 on[More]

ORA-02005: implicit (-1) length not valid for this bind or define datatype

Category:DefaultRelease time:-0001-11-30Views:130

Error received when attempting to login to Portal 3.0.8.9 using Internet Explorer 5.50.4522.1800CO (from Oracle OBI 5.0). Error does not occur when using Netscape 4.75. However, Netscape pegs CPU between every Portal page. I must maximize/minimize th[More]

ORA-00162: external dbid length 117 is greater than maximum(16)

Category:DefaultRelease time:-0001-11-30Views:130

A .net user facing this oracle issue any body plz identify the soution it will be very big help.This is the error. ORA-00162: external dbid length 117 is greater than maximum(16)Hello, What's your Database name? Can you post content of your tnsnames.[More]

ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified:

Category:DefaultRelease time:-0001-11-30Views:130

"ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275" I use the procedure to convert the documents if it is not already converted before using procedure as follows PROCEDURE "STARDOC"."HTMLOUTPUT&qu[More]

Hot
HI, As you all know, EBS Application Schemas (ex: AP, AR, GL, HR, etc) are associated with the DEFAULT profile and DEFAULT profile PASSWORD_VERIFY_FUNCTION is set to NULL. If I alter DEFAULT profile and set PASSWORD_VERIFY_FUNCTION to make use of a c [More]
Dear All, We have a requirement to Extract the data from Microsoft BI to Sap BI 7. How can we achieve this?? Shall we use the DB connection for this?? If anyone knows about this please give me some suggestion. Thanks in advance SathiyaHi All, How to [More]
I just installed 7.3, and I keep getting an error that says "The iTunes Library File cannot be saved. An unknown error occurred (-50)." Anyone know how to fix this? I tried to re-download, but can't since it is the current version. Thanks! MacBo [More]
I have all of my photos saved on a file server in my house.  I am using Photoshop Elements 11 on my desktop to catalog all of my photos. I am doing things like tagging photos and the people recogonition features.  If I install Photoshop Elements on m [More]
Hello, I need to have several buttons that do the same behavior. For brevity, I do not want to attribute to them each time a different instance name. Is there a way to perform many buttons the same function (eg trace ("foo");? And: 1)  without c [More]
Is the FireWire point Six or Four PinThere is a 6 pin Firewire 400, and 9 pin Firewire 800. You can plug a 400 to 800 converter cable into either depending on what you want to plug on the other end.Read other 4 answers [More]
I am using Lightroom 3.2 I would like to hack the HTML Web Gallery Engine to create unique title meta tags for each photo when it is selected for better search engine performance. I have been trying to mess around with the code and have not figured o [More]
Hi, Im doing a pH signal conditioning circuit and now Im done with the hardware part. So now im having a problem in Labview. Can anyone help me in this? In my program I need a section that allow user to calibrate the pH measured and a display of the [More]
Hi All.  We're looking into Data Management tools to go along with our PeopleSoft applications.  So far we have done a little looking into solutions from Informatica for Data-Archiving, Data-Subsetting, and Data-Masking.  All three appear to have pre [More]
I bought my MacBook early 2009 and recently my computer just turns off out of the blue. I'm in the middle of a Skype conversation and boom my computer is turned off. I plug it back in to charge it and the battery life says over an hour but before it [More]