HELP ORACLE8 BLOB & PL/SQL

Hi!

I am trying to read and write data into BLOB field using DBMS_LOB.READ & WRITE Procedures.

I could able to write data as per the parameters but when I want to read the same data, it is giving error ora-1403(no data found).

For writing into BLOB field, I have a table one ID field and BLOB field

First :

insert into my_table values(id, empty_blob());

select blob_field into blob_locater for update;

DBMS_LOB.WRITE(blob_locater, amt, offset, buffer);

amt = 10; offset = 1; buffer (of raw) =
'0101010101010101010100101001010101';

Successfully inserted.

When I want to read

select blob_field into blob_locater;

DBMS_LOB.READ(blob,amt, offset, buffer);

Gave error saying that ORa-1403.

PL help me in this - We need to implement BLOBs in our project in place of RAW fields of oracle7.3.

I would appreciate if u send a copy of ur reply to my email sburgadd_at_evolving.com

Thanks IN Advance

Sateesh Received on Wed Dec 24 1997 - 00:00:00 CST