Path: utzoo!censor!geac!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!uunet!infonode!tensmekl From: tensmekl@infonode.ingr.com (Kermit Tensmeyer) Newsgroups: comp.databases Subject: Re: Oracle to have text/memo data types, or blob soon??? Keywords: oracle blob Message-ID: <1990Dec31.161813.3605@infonode.ingr.com> Date: 31 Dec 90 16:18:13 GMT References: <19615@netcom.UUCP> <9165@cognos.UUCP> Organization: Intergraph Corp. Huntsville, AL Lines: 30 >In article <19615@netcom.UUCP> lpendley@netcom.UUCP (Lou Pendley) writes: >>I have settled on Oracle as a development platform, and am curious if >>they will soon, within the next 2 years, come out with a data type of >>memo/text that could contain a variable number of lines/characters, and >>if there will ever be a blob: binary large object. > > >You must be loyal if you want the function but are willing to wait up >to two years for a feature that many commercial systems have been supporting >in various degrees ! > > >-- >Nigel Campbell Voice: (613) 783-6828 P.O. Box 9707 I've been watching this and I guess I don't understand what the difference between blobs and Oracle's raw long type. SQL*Forms doesn't support (except on Sun's) long types. Is there some functionality in the kernal to support a memo/text data type that needs to be added. We're using Oracle to implement a publishing database and we're doing okay. As a trival thought, will SQL*Forms under Motif or (X11) allow use of longs as pict's or bitmaps? -- Kermit Tensmeyer | Intergraph Corporation UUCP: ...uunet!ingr!tensmekl | One Madison Industrial Park INTERNET: tensmekl@ingr.com | Mail Stop LR23A2 AT&T: (205)730-8127 | Huntsville, AL 35807-4201