Re: newbie PL/SQL questions

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 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||