Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:28

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
The iPod has been authorized with the computer already but for some reason all of the music on my iPod isn't showing. I want to reset the music on the computer's library and then just sync what's on my iPod onto it but I don't know how. Help?sasha399 [More]
Hi Specialist I created a payment medium using the transaction F110. In the Log Poporsal I didnt find any  error, but in the payment log I found it: BFIBL02167               Document 2000 1400259728 2011 either not found or reversed, payment not on p [More]
Does anyone else have the same problem as the one below? Ever since I upgraded to Leopard (day of release) there have been plenty of websites that do not finish loading, and what happens is that the tabs/websites just keep spinning. My ISP says nothi [More]
i donot know installation of the IBM jdk1.4.2_18amd64.rpm when i trying executing command rpm -i IBM jdk1.4.2_18amd64.rpm from terminal. it saying that libxp.so.6 is required so where it can be download my system configuration is os: RHEL 5.0 process [More]
Dear Friends, Is it possible to have multiple Ship to Addresses for One single vendor. The vendors are service providers to whom Installation material needs to be despatched ( One vendor would be operating from Various states). No invoices are to be [More]
RI am unable to update my apps now because I receive a message that I am not connected to the Canadian store.   How do I switch from the US store to the Canadian store?Click here and follow the instructions to change the iTunes Store country. (85848) [More]
I am asking this question for our Advertising department so I am not too close to the situation. Another company that is part of oujr platform designed their catalogs in Framermaker 7.0. We have Framemaker 6.0. The only reason we have it is to work w [More]
was using logic audio 6 then i got express 7 now i hav pro 7 ...... all the song file icons say 'logic express' song. is this normal? how am i supposed to know which program created the file FFS? without opening the file, and subsequently, each progr [More]
Hi, I have a requirement to update an infotype without authorisation check. Please let me know if there is any function module I can use to do that. Regards, LanwuHi, What is the functional requirement? Because basically it's the same as granting use [More]
I could not open my iphone because of that error, i was unable to restore my iphone's software. Is there any suggestions and comments? Thank you!Google it. You can not get help for your jailbroken phone here.Read other 2 answers [More]