Re: max length of long fields

Bryan Tower <btower_at_arlut.utexas.edu> wrote:

>Reposting article removed by rogue canceller.
 

>Hello
 

>I am having trouble inserting long strings into a long field. The
>Oracle7 manual says that a long field can hold up to 2G of data (or
>machine specific) but at present it is only holding 2K. I need it to be
>able to hold up to 30k. The error that I am getting is "Oracle error -
>ORA-01704: string literal too long."
>Is there a way to check/change the max length of a long field?
 

>Thanks
>Bryan

Just a thought from a new DBA, but have you tried inputing the data in a differnet way. If you put in a quoted string you're stuck at a 2K max.

jvince19_at_mail.idt.net Received on Fri Sep 27 1996 - 00:00:00 CEST