How to retrieve file from BLOB database object
843853Jul 11 2001 — edited Jul 12 2001I am storing file in a BLOB object in Oracle database.While retrieving the file from database,if the file size is less than 5KB then file content will retrieving properly ,but if the file size is greater than 5KB then it's retrieving nothing.Please guide me how to retrieve the bigger files.
while creating the BLOB object i make use of following code
CREATE TABLE TEST
(TEST BLOB)
LOB(TEST) STORE AS
(STORAGE (INITIAL 100k NEXT 100K))