Re: INSERT only up to 250 Characters?

From: Magnus Lonnroth <mloennro_at_us.oracle.com>
Date: Thu, 26 Aug 1993 00:37:49 GMT
Message-ID: <MLOENNRO.93Aug26013749_at_wrpyr4.us.oracle.com>


In article <1993Aug25.081443.15177_at_trantor.dso.gov.sg> 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?

In Forms v3 (and v4) you can manipulate variables of type VARCHAR in a PL/SQL block, function or procedure, with a max length of 2000 bytes. Does this help ?

cheers,

Magnus Lonnroth
Tech.Sales & Consultant
Oracle Sweden

[My opinions are not supported] Received on Thu Aug 26 1993 - 02:37:49 CEST

Original text of this message