Re: BLOB to File

From: stephen O'D <stephen.odonnell_at_gmail.com>
Date: 7 Oct 2005 06:40:25 -0700
Message-ID: <1128692424.985868.211070@g44g2000cwa.googlegroups.com>

Robert wrote:
> 9i and up - Anyway to get a 4 mb & up BLOB to file on disk ?
>
> UTL_FILE error:
> blob length:3967200 error in PUT_LOCAL_BINARY_DATA
> ORA-29285: file write error
>
> so UTL_FILE is out of the question
> thanks

Did you use UTL_FILE.Put_Raw?

In PLSQL you can only have 32767 bytes in a RAW var at one time, so if you BLOB is bigger than that, you will need to print it out as a series of chunks using dbms_lob.substr ...

Stephen. Received on Fri Oct 07 2005 - 08:40:25 CDT