Hi all,
CREATE OR REPLACE procedure testblobwrite as
l_header raw(32767);
lengte integer;
v_blob2 BLOB;
begin
l_header := utl_raw.cast_to_raw('hallo.txt' || chr(0));
lengte := length(l_header);
dbms_lob.createtemporary(v_blob2, TRUE, dbms_lob.session);
dbms_lob.open(v_blob2, dbms_lob.lob_readwrite);
dbms_lob.write(v_blob2, lengte, 1, l_header);
end;
/
begin
testblobwrite;
end;
ORA-21560: argument 2 is null, invalid, or out of range
ORA-06512: at "SYS.DBMS_LOB", line 811
ORA-06512: at "RIGHTSHOP.TESTBLOBWRITE", line 11
ORA-06512: at line 2
gives above error
what am I doing wrong?
TIA
Kr
Martin