Re: Help with LONG

Hi Joseph,

It is not so simply. Rick wanted to load longs up to 65k. PL/SQL supports only 32k longs in Oracle 7. OCI or Pro C application should be used for these purposes.

                    Andrew Protasov

joseph Li wrote in message <6h4t0m$gj1$1_at_otis.netspace.net.au>...
>Where is you input coming from ? If input is a text file with lines
>ended in <CR>, and you want to put the whole input file into the LONG
>column. The package UTL_FILE allows you to read the lines from the
>input file into a PL/SQL variable which is concatenated with the LONG
>column. You need to use loops in PL/SQL, I think.
>
>Joe
>
>In article <3531F67F.41C6_at_variagenics.com>, Rick Stacy
 <rstacy_at_variagenics.com> says:
>>
>>Hi,
>>
>>Could someone please pass along some words of wisdom while I await
>>the arrival of my documentation set?
>>
>>Using the Oracle7 server, I want to insert character strings (up to
>>65K in length) into a LONG column. What is the best way to do this?
>>When I tried to insert a 3K string via a basic INSERT statement I
>>received the following error:
>>
>> PARSE caused a ORA-01704: string literal too long
>>
>>I'm flying blind without the documentation, so any information you
>>could provide would be greatly appreciated.
>>
>>Thanks in advance.
>>
>>--
>>Rick Stacy |
>>Senior Scientist, Bioinformatics | I didn't claw my way to the top of
>>Variagenics, Inc. | the food chain to eat veggies!
>>rstacy_at_variagenics.com |
Received on Fri Apr 17 1998 - 00:00:00 CEST