Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

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 contemplating the Monastery: (4)
As of 2018-07-19 04:29 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (402 votes). Check out past polls.