Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> BFILE & LOB questions?
Using Oracle 8.0.5 Here is what I did:
inventory_item_id NUMBER NOT NULL,
item_image BFILE default NULL
)
/
insert into item_images values (5112277, BFILENAME('BFILE_DIR', 'pin.gif'))
/
insert into item_images values (5112279, BFILENAME('BFILE_DIR', 'lip.gif'))
/
commit
/
INTO Lob_loc FROM test_item_images
DBMS_LOB.READ (Lob_loc, Amount, Position, Buffer); Position := Position + Amount;
Please reply to the newsgroup.
Eddie.
Received on Thu May 04 2000 - 00:00:00 CDT
![]() |
![]() |