Hello List!
Have a quick question that I am sure someone knows the answer to. I
switching from handling long raw data in Oracle to only storing a pointer to
the file on the file system. I am dealing mostly with PDFs.
The process seems/ed pretty easy: select the contents of the longvar column
Levon,
You might try using the binmode function on your filehandle:
open FH, $binObjId.pdf;
binmode FH;
print FH, $contents;
close FH;
Steve
On Thu, Jul 24, 2003 at 11:26:52AM -0400, Levon Barker wrote:
Hello List!
Have a quick question that I am sure someone knows the
Thanks Steve,
That was the solution.
Cheers,
Levon Barker
-Original Message-
From: Steve Mayer [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:41 AM
To: Levon Barker
Cc: [EMAIL PROTECTED]
Subject: Re: Perl + Oracle + Blobs + PDFs - Dumping to filesystem
Levon
while ($sth-fetch()) {
open FH, $binObjId.pdf;
print FH, $contents;
close FH;
}
That almost works.
After this runs on a coulple of files, I try to open one, and
the PDF reports that the file is damaged and also none of the
jpgs that were embedded in the PDF
Thanks for the quick response Dan, that solution is correct, but Steve beat
you to the punch. :)
-Original Message-
From: Dan Muey [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 11:35 AM
To: Levon Barker; [EMAIL PROTECTED]
Subject: RE: Perl + Oracle + Blobs + PDFs - Dumping
To: Levon Barker
Cc: [EMAIL PROTECTED]
Subject: Re: Perl + Oracle + Blobs + PDFs - Dumping to filesystem
Levon,
You might try using the binmode function on your filehandle:
open FH, $binObjId.pdf;
binmode FH;
print FH, $contents;
close FH;
Steve
PROTECTED]
Subject: RE: Perl + Oracle + Blobs + PDFs - Dumping to filesystem
while ($sth-fetch()) {
open FH, $binObjId.pdf;
print FH, $contents;
close FH;
}
That almost works.
After this runs on a coulple of files, I try to open one