Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: copy LONG RAW data with Oracle7

Re: copy LONG RAW data with Oracle7

From: mark tomlinson <micro_at_work.org>
Date: Thu, 28 Jan 1999 00:03:17 GMT
Message-ID: <36afa8a3.8511798@newshost.us.oracle.com>


With the Oracle 7.x RDBMS, manipulating LONG and LONG RAW data really needs to be done in a 3GL (C/C++/COBOL/Etc...) external to the RDBMS itself. PL/SQL variables are limited to 32k in size, which significantly restricts how much data you can move about this way. With Oracle 8 (and LOB column types) you can do piecewise manipulation of the LOB data in PL/SQL quite easily. Received on Wed Jan 27 1999 - 18:03:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US