beginner: how to download pdf stored as LOB?

From: <bethesdananny_at_gmail.com>
Date: 11 Apr 2007 17:34:56 -0700
Message-ID: <1176338096.835482.309590@e65g2000hsc.googlegroups.com>

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! Received on Wed Apr 11 2007 - 19:34:56 CDT