I am passing a 50 K photo image to a stored procedure. Initially we thought we pass the filepath and load it into database using dbms_lob.loadfromfile(). However, this is not feasible because the file is on the client. We want to pass the actual BLOB value into the stored procedure which will do a SQL insert into the database.

Is this possible? Do i hit a 32K PL/SQL buffer limitation?

Again I want to pass the value not the locator directly.