Re: Particular file (PDF) cannot be loaded into Oracle BLOB. Makes sense ?

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Thu, 17 Mar 2011 21:29:24 -0400
Message-ID: <Vzygp.479779$ZM.125237_at_en-nntp-02.dc1.easynews.com>


"onedbguru" <onedbguru_at_yahoo.com> a écrit dans le message de news: 1ce00a7c-f5d5-4c17-8230-49b41479453e_at_u8g2000yqh.googlegroups.com... On Mar 17, 11:41 am, "Syltrem" <syltremz..._at_videotron.ca> wrote:
> "gazzag" <gar..._at_jamms.org> wrote in message
>
> news:828ea98b-bb94-4ee2-88f3-43b037836f54_at_k9g2000yqi.googlegroups.com...
> On Mar 17, 1:34 pm, "Syltrem" <syltremz..._at_videotron.ca> wrote:
>
>
>
>
>
>
>
>
>
>
>
> > No error. It's just that some extra characters are added into the BLOB.
> > For instance, I see that a 0A is added following each 0C (LineFeed added
> > following each FormFeed).
> > So if the PDF contains 50 FormFeeds, then 50 LineFeeds are added, making
> > 50
> > characters to be truncated from the end of the file (the BLOB length
> > always
> > matches the file's length).
>
> > And the problem is with INSERTING the file into the BLOB. The extraction
> > from Oracle is not the problem, which I can prove by loading the same
> > PDF
> > with a dot net program, and extracting it successfully with the same
> > extraction procedure. dbms_lob.loadBLOBfrofile does the damage.
>
> > This is with 10.2.0.4
>
> > Yesterday, I downloaded Acrobat Pro trial version. I created a new PDF
> > file
> > with it (from a MS-Word document), loaded it into Oracle, and could not
> > retrieve it in good condition. I have not gone into the details yet but
> > I
> > suspect the same problem.
> > Strangely, I have other PDF coming from different sources, that work
> > without
> > problem. Actually, I was surprised that I could not use a PLSQL program
> > that
> > I used for a couple of years to load other PDFs, to load these new ones.
> > Can't tell what Oracle does not like about these new ones.
>
> > And yes I see there are many example out there showing how to load and
> > extract PDF with Oracle, but non mentions that some PDF (nor any other
> > file
> > types) are not "supported".
>
> > Thanks
> > Syltrem
>
> > Not sure if I posted this properly, so will try again:
>
> > Do you have any O/S details? Could it be a MS Windows / Unix CR/LF
> > conversion issue?
>
> > HTH
>
> > -g
>
> Production is on OpenVMS 8.4 / Itanium but I also tried with Windows XP,
> Oracle XE and got the same problem.
>
> Syltrem
>
> How did you get the file onto the OpenVMS server? ftp? Did you use
> binary mode? - I think that you probably already know that, but just
> checking.
>
> M.
> ex-DECcie - RDB Rules.

I know that and it's not the problem.

Conversely, If a windows dot net program loads the file into the BLOB, then PLSQL extracts it, it's good for Acrobat. Actually, this will create an extracted file that's an exact copy of the original file. But dbms_lob.loadblobfromfile breaks the file when loading it into the blob.

It does so on Windows too (Oracle XE) when OpenVMS is nowhere involved (when the PDF file is local to the Windows system)

Syltrem Received on Thu Mar 17 2011 - 20:29:24 CDT

Original text of this message