Posts Tagged ‘Oracle Applicaions’

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 into any form.
 
Calling program [...]