Re: using UTL_FILE and HEXTORAW()

On 21 Apr 2006 11:50:46 -0700, "CJ" <spambox1_at_mindspring.com> wrote:

>need to write "binary" data, specifically a record separator byte
>(x1E), to a file. When I do so using "UTL_FILE.put_line(file_handle,
>HEXTORAW("1E"));" I end up with an ASCII hex string of "1" "E", two
>bytes not one with 0x1E followed by "newline."
>
>1) is put_line converting the HEXTORAW() output back to a string?
>2) how can I write a byte of x1E to a UTL_FILE.FOPEN() handle?
>
>Thanks in advance.
>CJ

2 Know the chr function? If not, look it up in the sql reference manual.

--
Sybrand Bakker, Senior Oracle DBA