Re: INSERT only up to 250 Characters?

From: Daniel B. Bikle <dbikle_at_cco.caltech.edu>
Date: 26 Aug 1993 05:42:28 GMT
Message-ID: <25hig4INNkgo_at_gap.caltech.edu>

kkimchio_at_trantor.dso.gov.sg (Kwa Kim Chiong) writes:

>Oracle allows definition of LONG data type that supports up to 65K
>characters. It is ironical that SQL INSERT (from SQL Form) can only insert
>up to 250 characters. We were asked to try Pro C to overcome this problem.
>Does anybody have any better suggestions?

I would not call this a "better suggestion" but you might consider it.

Last year I used SQL*TextRetreival (tm) to load data from text files into a LONG data type. It was cumbersome and time consuming but it did work.

-Dan

---

Daniel B. Bikle
Independent Oracle Consultant
dbikle_at_alumni.caltech.edu
415/854-9542

---

Received on Thu Aug 26 1993 - 07:42:28 CEST