RE: LONG RAW append question

You can use utl_raw.concat(r1,r2.....,r12). However each raw argument cannot exceeds 32k. If you are using 8i, why don't you change to BLOBs and use the dbms_lob.append to satisfy your purpose ?. Maybe you can achieve your goal with temporary LOBS in a PLSQL but I don't know if it would work.

Regards.

> -----Mensaje original-----
> De: Vulpe Marius [SMTP:marius_v_at_pathos.ro]
> Enviado el: lunes 19 de marzo de 2001 18:06
> Para: Multiple recipients of list ORACLE-L
> Asunto: LONG RAW append question
>
> Hi!
>
> I am trying to make an application that insert some binary data into
> a Oracle database. The technology I use is Enterprise Java Beans. The
> Client sends pieces of binary information that I want to put in the
> database. The problem is that I don't know how to make an append to a
> LONG RAW column in a table. The question is: can I do it? If yes, how
> can I do that (what is the SQL syntax)?
>
> Best regards,
> Vulpe Marius
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vulpe Marius
> INET: marius_v_at_pathos.ro
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).