This is my problem :
one table with a long column.
one table with a lob column.
I want to concat some of rows from the first table in the second one.
I write this procedure :
PROCEDURE ADD_LONG2LOB (pio_res IN OUT CLOB, pi_add IN long)
IF pi_add IS NOT NULL THEN
select vsize(pi_add) into v_size from dual;
WHEN OTHERS THEN
Raise_Application_Error('-20001','Error PROCEDURE ADD_LONG2LOB');
It works except with some rows. For these rows, the function vsize doesn't work.
Could you post a workaround for this?
A very quick reply would be greatly appreciated.
Click Here to Expand Forum to Full Width