Re: beginner: how to download pdf stored as LOB?

bethesdananny_at_gmail.com wrote:
> Hi,
>
> Beginner here using an SQL SELECT statement to try to download a pdf
> file stored as an LOB via an ODBC driver.

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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org