File contents into BLOB in Oracle Database, using PL/SQL
Often there will be a requirement for reading .out files generated by Oracle Applications and converting into pdf files and send as mail attachment. Here is a sample PL/SQL procedure which can read a file from a specified location, into a BLOB and returns it. The calling program can convert this blob data [...]
