Hi,

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

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 container
field 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!

On Apr 11, 5:38 pm, bethesdana... (AT) gmail (DOT) com wrote:
Honestly, I'd try to sort this out outside of filemaker first. Once
you can reliably get the file out of Oracle through the ODBC drivers
you are using -then- try doing that query from within FM.

If the error is coming from Oracle or the ODBC drivers it would be
easier to troubleshoot and diagnose if you took FM out of the picture.

-regards,
Dave