Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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 BortelReceived on Wed Apr 23 2003 - 12:30:40 CDT
![]() |
![]() |