i am declaring CLOB datatype, even though it is taken internally varchar(32767).
once it is exceed(32767) it is getting error.but variable is CLOB.
can u please suggest me how to over come this error.
create table abcd(abcd clob);
DECLARE
K CLOB;
BEGIN
DELETE FROM ABCD;
COMMIT;
FOR I IN 1..17
LOOP
K:= K||'A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th
A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th A cursor FOR loop implicitly declares its loop index as aasdfdafasdfasdfsadfhes rows of values from the result set into fields in th'||I;
END LOOP;
INSERT INTO ABCD VALUES(k);
dbms_output.put_line(length(k));
COMMIT;
END;
/