Hiiii I am using Oracle8i Enterprise Edition Release 8.1.6.0.0 .

1) create table tdtech11(CID VARCHA2,CD CLOB,IMAGE BLOB,DETAILS BFILE);
INSERT INTO TDTECH11 VALUES(2,'DDDD',EMPTY_BLOB(),BFILENAME('TDTECH','PICTURE1.JPG'));

3)RUN THE PROCEDURE,AFTER THAT I GET ERROR

HII THANKS Raminder UR REPLY
BUT I EXECUITED UR PROCEDURE IT RETURN ERRORS
LIKE*************

CREATE OR REPLACE PROCEDURE loadLOB_proc IS
Dest_loc BLOB;
Src_loc BFILE := BFILENAME('TDTECH', 'picture1.jpg');
Amount INTEGER := 4000;
BEGIN
SELECT COMPANY_MAP INTO Dest_loc FROM TDTECH11
WHERE COMPANY_ID = 'TD1' FOR UPDATE;
DBMS_LOB.OPEN(Src_loc);
DBMS_LOB.OPEN(Dest_loc);
DBMS_LOB.LOADFROMFILE(Dest_loc, Src_loc, Amount);
DBMS_LOB.CLOSE(Dest_loc);
DBMS_LOB.CLOSE(Src_loc);
COMMIT;
END;

** ERRORS

-----------------------------------------------------------------
PLS-00306: wrong number or types of arguments in call to 'OPEN'
PL/SQL: Statement ignored

HIIII HOW TO OVER COME THIS ERROR?
THANKING U