beginner: how to download pdf stored as LOB?

Hi,

Beginner here using an SQL SELECT statement to try to download a pdf
file stored as an LOB via an ODBC driver.

I'm actually hitting a BFILE and (miraculously!) it seems to at least
open the file based on the pointer in the column and I am able to
download about half of the pdf (approx 100k characters) before getting
an ODBC error right string truncated.

I am downloading from Oracle9 (I think) into a Filemaker Pro
"database" field that is capable of holding up to 4GB so I don't think
it's getting truncated at my end. Running Windows XP.

Do I have to specify the length the file? Or the fact that it's an
LOB?

IT people I've spoken with seem surprised that I'm able to get even
half of the file - hope there is a solution to get the whole thing.

Help greatly appreciated.

Thank you!

.

Relevant Pages

  • ODBC to download LOB
    ... Beginner here using an SQL SELECT statement to try to download a pdf ... file stored as an LOB via an ODBC driver from FMP. ...
    (comp.databases.filemaker)
  • Re: ODBC to download LOB
    ... Beginner here using an SQL SELECT statement to try to download a pdf ... file stored as an LOB via an ODBC driver from FMP. ... If the error is coming from Oracle or the ODBC drivers it would be ...
    (comp.databases.filemaker)
  • Re: beginner: how to download pdf stored as LOB?
    ... file stored as an LOB via an ODBC driver. ... Where is the PDF file? ... What ODBC driver and what does it have to do with anything? ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.misc)
  • Re: Potters favorite computer programs.
    ... > They can be download from the Internet and most are free. ... > 5D PDF - Creates PDF files via the print command. ... > Microsoft PhotoStory - use to make pictures into DVDs and videos. ... > CDBank - reads in and catalogs the directories of your disk drives, ...
    (sci.physics)
  • Re: Can doc and pdf files be treated this way?
    ... Downloading the .html document from the site, editing it locally and then ... but I don't know about the PDF ones. ... >> I've begun to design a Web page that will allow users to either download ...
    (microsoft.public.frontpage)