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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to