Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1002840]
Approved by rovf
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (6)
As of 2018-03-24 16:37 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (299 votes). Check out past polls.