Re: Upper CLOB in 8i

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