I've got a table in an Oracle 12g db that is BLOB for storing files. I'm trying to find a way to get the size of a single file contained within the BLOB column.
I am not saving the file to the server before inserting it into the db; it is going straight to the db to cut down on disk i/o, so I can't get the file size before inserting.
^ _ ^
Nevermind. This has become a non-issue. Given the lack of activity on the Adobe forums, and pressing time to get things done, I have been forced into a rather hackish way of getting the information I require. I am posting the solution below.
I hate doing it this way, but don't have much choice as the project is launching on Monday.
^ _ ^
var fileInput = document.getElementById('upload'), files = fileInput.files, fileName = files.size + "|" + files.name;
SELECT REGEXP_SUBSTR(doc_name,'[^|]+',1,1) "DOC_SIZE", REGEXP_SUBSTR(doc_name,'[^|]+',1,2) "DOC_NAME"
FROM documents doc