From: Tim Witort Subject: Re: newbie PL/SQL questions Date: 1997/09/09 Message-ID: <3415953F.702F@NOSPAMmedicalert.org>#1/1 References: <341544cb.102936965@129.88.30.1> Reply-To: trwNOSPAM@NOSPAMmedicalert.org Organization: Netcom X-NETCOM-Date: Tue Sep 09 1:33:03 PM CDT 1997 Newsgroups: comp.databases.oracle.misc Romuald Jouffrey wrote: > > Hi, I got 2 questions in > > I would like to receive and record a file, but varchar2 is limited to > 2000 chars long. What can be done ? In PL/SQL, a VARCHAR2 can hold up to 32K characters. If that is not enough, then your only option is to use multiple VARCHAR2s. In PL/SQL, even a LONG is limited to 32K, so if 32K is not enough... -- TRW -- ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trwATmedicalertDOTorg || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||