Sitemap

Amicuk Programming Answers

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

-0001-11-30   Views:35

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, I just uploaded 5 movies from my camera to my iMac using iPhoto. I can see them all in there. Here is a photo. When I drag the movies out you can see in this picture above the iPhoto app (top left). If you notice an older one has the Quicktime sy [More]
The downloading process was stucked in the Thank You screen ("Your update is downloading... ") for more than 2 hours and not going anywhere, nothing was downloaded at the end.  Anybody has the same issue before? Reported to the help desk for mor [More]
I have been getting a pattern of errors on my DC. I have two pair of eyes on these errors, but everything seems to running ok. The only issue we've had is our workstations were putting out the "Trust domain relationship failed..." error. We were [More]
How do I create a blank signature block in Acrobat Pro X for someone else to sign?You create a signature field.Read other 2 answers [More]
When starting up with my macally usb 4-port powered hub connected to the mac, open firmware hangs with following error message on a gray screen GETCLASSDESCR for Hub error0ff927ef8 ffbd8c90 9 DEFAULT CATCH!, code 300 at %SRR0: _ Booting up with usb-h [More]
Hi,     We Need to build Payment release workflow for MIRO invoice.     If the invoice amount exceeds 10000, that line item need to be blocked and shoudl be sent a mail for approval.     My doubt is, whether the  payment blocking is done by configura [More]
I am having trouble getting in to use iTunes and icloud on my desktop windows 7. Saying that I'm not connected to server, but I am accessing the Internet though. Also am receiving emails but cannot send them......aaaaaagh!Close your iTunes, Go to com [More]
Hi folks, My Mountain Lion upgrade has resulted in random kernel panics. I've unistalled all apps that have been cited as potential problems and also tried reinstallign Mountain Lion from both the recovery partition and by redownloading from App Stor [More]
Hi In general, I save my documents as uncompressed TIF files. On a recent project I have noticed that the files being created appear particularly large and are significantly bigger than the size indicated in the status bar. An example: Document is 16 [More]
Hi Is there anyone who have managed to install nvidia optimus GT 630m in ubuntu or any other OS linux and worked?? coz I did all the methods which are available on net, but no luck, found out that Bumblebee can't get to enable Nvidia!! is it right?? [More]