Re: Convert varchar2 -> BLOB

Jeremy wrote:
> Platform: Oracle 9ir2 on Solaris 9
>
> Hi folks what is the easiest way to do this?

Buying it, not re-inventing wheels

> We are using UTL_HTTP.REQUEST_PIECES to retrieve whatever is at the end
> of a URL. This may be an HTML doc or perhaps a PDF or MS Word doc.
>
> 1st question actually is: can we get binary data using this interface?

Read UTP_HTTP - it has a read_raw procedure, too. OWA.GET_PAGE_RAW might help, too
>
> 2nd question: what is easiest way of converting the stream of data that
> we receive into a BLOB so that we can then reconstruct the original
> file?
>

Not sure I understand - the blob contains the original file. Just write it, using e.g. UTL_FILE.

-- 
Regards,
Frank van Bortel