write into lob variable

From: Shishir <shishir_at_agnisoft.com>
Date: Wed, 21 Nov 2001 06:29:45 -0800
Message-ID: <F001.003CA811.20011121054521@fatcity.com>

Hi Gurus!
i have one problem :

While writing the data into a blob type of variable inside a procedure using
blob_type

str:='shishir';//
varchar2blb:= empty_blob(); // blob type of variableTRAW:=utl_raw.cast_to_raw(str); // Raw type <FONT face=Arial>offset=1;dbms_lob.write(blb,length(str),offset,TRAW);

it is giving error "Invalid LOB locator specified"

i would help from any of
u.
Thanx in advance
Shishir Kumar
MishraAgni Software (P) Ltd.,Bangalore-560055, India

Received on Wed Nov 21 2001 - 08:29:45 CST