Help me with Lobs Please

From: Tom Zamani <tom_at_taten.com.au>
Date: Tue, 21 Sep 1999 16:03:26 +1000
Message-ID: <7s772j$kje$1@perki.connect.com.au>

Could you help me with this
I get 22288 error

Thank you.

CREATE OR REPLACE procedure insrt_lobs(lvEdition_ID in number default 1) is
--

ac clob default null;
amount number;
a_file bfile;
--

begin

--

update edition set

    TEMP_CLOB = empty_clob()
where EDITION_ID = lvEdition_id;
--

commit;
a_file:=bfilename('PUBDIR',lvEdition_ID||'.txt'); select TEMP_CLOB into ac from edition where EDITION_ID = lvEdition_id for update;
--select ITEM_HTMLCLOB into ac from ITEM_CLOBS where item_ID = 4065 for
update;
--select ITEM_TMPTEXT into ac from item where item_ID = 3999 for update;
--

commit;
dbms_lob.fileopen(a_file,dbms_lob.file_readonly); amount:=dbms_lob.getlength(a_file);

dbms_lob.loadfromfile(ac,a_file,amount);
dbms_lob.fileclose(a_file);
dbms_output.put_line(amount);

--exception when others then
--dbms_lob.filecloseall;
--dbms_output.put_line(amount);
--

end;
/ Received on Tue Sep 21 1999 - 01:03:26 CDT