Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 9i Bulk Insert Bug
Looks like bulk inserts are screwed up in 9i if you change a table
element to null. Can someone please confirm this bug with the test
script below? Anybody with a version greater than 9.0.1.0.0 see it
fixed? Note, this works fine in 8.1.7.2.0.
drop table x;
create table x (value number);
declare
type ttab_value is table of x.value%type index by binary_integer;
tab_value ttab_value;
begin
tab_value(1) := 1; tab_value(1) := null; if tab_value(1) is null then dbms_output.put_line('the value in index 1 is null'); end if; forall i in 1 .. 1 insert into x ( value ) values ( tab_value(i) );
end;
/
select 'Everything is ok, no bug detected' as test_result from x where
value is null;
select 'THIS IS A BUG!!! VALUE SHOULD BE NULL' as test_result from x
where value is not null;
Received on Tue Apr 16 2002 - 16:00:42 CDT