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: LONG to long in Oracle?

Re: LONG to long in Oracle?

From: Branko Milosavljevic <mbranko_at_EUnet.yu>
Date: 1998/02/04
Message-ID: <6bbkam$sn2$1@SOLAIR2.EUnet.yu>#1/1 







As far as I know, string literals cannot exceed 2000 chars
(Oracle7) or 4000 chars (Oracle8). If you need to insert
a literal longer than 2000 chars in a LONG column you have
to cut the string into 2K pieces. I made a PL/SQL package for
this.



HTH



Branko Milosavljevic
Received on Wed Feb 04 1998 - 00:00:00 CST












Original text of this message













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