Re: how to get a BLOB from a table to OS?

dominica_at_gmail.com wrote:
> Hi All,
>
> I am trying to get a BLOB from a table to OS(unix)?
>
> Someone give me hint on how to use dbms_lobs function and
> dump the output to os?
>
> Anyone has done this before?
> I know it could be done.
>
> You know what I am trying to archive, I am actually
> testing an oracle upgrade from 8.1.7.4 to oracle 10g.
> And I want to make sure after the 10g upgrade, my BLOB
> inside the database, like pdf are still pdf file, not
> become JUNKS.
>
>
> Dominica

For 10g

http://www.psoug.org
click on Morgan's Library
click on UTL_FILE
scroll down to the Extract BLOB demo at the bottom of the page.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)