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!

Can not be done the way you are trying.

Lets start at the beginning.
1. What Oracle version number?
2. Where is the PDF file?
3. What ODBC driver and what does it have to do with anything?
4. Have you heard of UTL_FILE?
5. Have you heard of DBMS_LOB?
--
Daniel A. Morgan
University of Washington
damor@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org