Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Create OLE file object container

by ACTH (Initiate)
on Nov 08, 2012 at 08:53 UTC ( #1002840=perlquestion: print w/ replies, xml ) Need Help??
ACTH has asked for the wisdom of the Perl Monks concerning the following question:

I need to process mail attachments (PDF, Word, JPG etc.) and insert these files in to an Oracle database. The Perl code doing the mail extracting and database insertion I have working without any problems. The files are readable when I extract them from the database with another Perl script.

The problem is that the Oracle database has an Microsoft Access (ODBC) interface for several users. Access cannot display the files in the Oracle database because they are not in an OLE container.

Is there a way to wrap a file in an OLE container with Perl? When you add a file via the Access into the database it automatically adds a OLE header/footer to the file. The header is different for each file type and file size and I can't find any information about the OLE container definition for PDF, Word of JPG. Looked at WIN32::OLE but could not find anything about OLE file wrapping.

Would appreciate any help / pointers with this problem.

Comment on Create OLE file object container

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1002840]
Approved by rovf
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2014-08-30 08:22 GMT
Find Nodes?
    Voting Booth?

    The best computer themed movie is:

    Results (291 votes), past polls