Re: Particular file (PDF) cannot be loaded into Oracle BLOB. Makes sense ?
Date: Fri, 25 Mar 2011 09:37:41 -0400
Message-ID: <GU0jp.32047$Lj7.2214_at_en-nntp-03.dc1.easynews.com>
"onedbguru" <onedbguru_at_yahoo.com> wrote in message news:20930423-a6d5-4ac2-ab2f-94d0b3c804e4_at_x8g2000prh.googlegroups.com...
On Mar 24, 2:06 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <XsLip.726032$Bh.128..._at_en-nntp-12.dc1.easynews.com>,
> syltremz..._at_videotron.ca says...
>
>
>
> > I'm still in doubt with all Oracle support told me about the files
> having to
> > be "supported" (or be of an Oracle "known" type).
>
> I think that is utter rubbish. It's just bits.
>
> --
> jeremy
>
> Yes, bits is bits except when you take a binary file and add CR/LF
> pairs when it shouldn't. IIRC, there is/was a switch somewhere that
> caused SAMBA to leave the file alone an not try to "translate" it - it
> behaves as if the file is transferred to the SAMBA share on VMS in
> ASCII mode which adds the CR/LF because it is not smart enough to know
> that it is a binary vs a text file.
>
Possible, but strangely Samba can retrieve the file from VMS and present it to Acrobat running on Windows, and Acrobat is happy with it. So it's unlikely that going to HP to get support on Pathworks (Samba) will go anywhere as it's fine from their point of view.
But obviously when you *don't* use Samba to read the file, it seems to be
misinterpreted.
When I FTP the file to VMS it gets there as a fixed length record size, 512
bytes.
When using Samba, it's variable size records. So possibly Oracle thinks it's
some ascii file ending with CRLF and does not load it properly. I could
probably play with the file/record attributes and get it to work but I
already worked around the problem so for this time, I'm finished with that.
At least I know what's wrong, as it could happen again with other files and
I'll know what to do.
Syltrem Received on Fri Mar 25 2011 - 08:37:41 CDT