Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Upper CLOB in 8i

Re: Upper CLOB in 8i

From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 23 Apr 2003 19:30:40 +0200
Message-ID: <3EA6CDC0.9040402@netscape.net>


Ingo wrote:
> Hi all,
>
> I'm trying to write a PL/SQL-function on an ORACLE 8i database to upper the
> content of a CLOB-column. Has anybody done something like that yet?? Could
> anybody help (send a code snippet)??
>
> Best regards,
> Ingo.
>
>

I did something like this - a search in a long. In pseudo code - and you need to find the LOB manipulation packages yourself:

define a varchar2(4000) (can be 32kB if in PL/SQL) define pointer
while not end-of-clob and left_space_of_clob>4000:

   move 4000 bytes to varchar
   upper varchar
   move to output buffer (other clob?)
   up pointer with 4000, or what's left
end while

-- 
Regards, Frank van Bortel
Received on Wed Apr 23 2003 - 12:30:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US