Hi
I have this table
create table SIUCREDITO.CLOBTABLE
(
ID varchar2 (20),
CAMPO clob,
LOG_DATA timestamp (6) default systimestamp not null
);
and this procedure that insert into the table above:
create or replace procedure SIUCREDITO.insproc (campo clob, id varchar2)
is
pragma autonomous_transaction;
begin
insert into clobtable (campo, id)
values (campo, id);
commit;
exception
when others
then
rollback;
end insproc;
The test script:
declare
vCLob clob := 'zz';
begin
for x in 1 .. 1000000
loop
vClob := vClob || 'a';
end loop;
siucredito.insproc (vClob, 'aa');
end;
If I launch the script it works fine. Why ?
I concat a string to a clob and the concat operator is applied to strings.
32767 bytes are exceeded.