stephen O'D wrote:
> 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.
On the contrary. Go to the UTL_FILE page in Morgan's Library
(www.psoug.org). Scroll down to the bottom and look at the Extract
BLOB Demo. PUT_RAW can be used to write out any size BLOB.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 07 2005 - 10:46:23 CDT
