SQL & PL/SQL

Hi all,

I have CLOB column szb_szablon_clob which about 200 rows

I want use oracle translate to change special characters (for example 'Ś' to '¦')

No problem if szb_szablon_clob have 4000 (or less) chars because then i use below code

update vbt_szablony
set szb_szablon_clob = translate(DBMS_LOB.SUBSTR((select szb_szablon_clob from vbt_szablony where szb_nazwa = 'FTMP118000'),4000,1),'¦', 'Ś')
where szb_nazwa = 'FTMP118000';

But how can use it when more than 4000 ?

I try combinations with cursors and DBMS_LOB.SUBSTR in loop but without effects..

Can you give me some idea or send to a similar problem in forum ?

Thanks for you time

Edited by: Ndejo on 2012-04-26 11:36