beginner: how to download pdf stored as LOB?
- From: bethesdananny@xxxxxxxxx
- Date: 11 Apr 2007 17:34:56 -0700
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!
.
- Follow-Ups:
- Re: beginner: how to download pdf stored as LOB?
- From: DA Morgan
- Re: beginner: how to download pdf stored as LOB?
- Prev by Date: Re: timestamp format
- Next by Date: Re: beginner: how to download pdf stored as LOB?
- Previous by thread: timestamp format
- Next by thread: Re: beginner: how to download pdf stored as LOB?
- Index(es):
Relevant Pages
|