Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-21560: argument 2 is null... DBMS_lob.write

MartijnkeJul 30 2009 — edited Jul 31 2009
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
This post has been answered by rbglossip on Jul 30 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2009
Added on Jul 30 2009
2 comments
3,974 views