Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 9i Bulk Insert Bug

9i Bulk Insert Bug

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 16 Apr 2002 21:00:42 GMT
Message-ID: <_h0v8.50458$zN.22982849@twister.socal.rr.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US