Re: Datenformat LONG

From: Manuela Mueller <520040906697-0001_at_t-online.de>
Date: Wed, 09 Jan 2002 23:02:37 +0100
Message-ID: <3C3CBDFD.6B573EDA@t-online.de>

Thomas Troendlin wrote:
>
> Hallo Gemeinde,
>
> Gibt es einen einfachen Weg (unter 20 Zeilen PL/SQL) Tabellen die eine
> Spalte im LONG Format besitzen, entweder direkt oder über Umwege nach
> VARCHAR2 konvertiert ?
>
> Ansonsten kann man ja wohl mit LONG wenig anfangen.
>
> Danke
>
> Thomas

Hello Thomas,
please post in english, do not multipost and include OS und Oracle Version.
Regarding your question: It is unclear if you have an old application that forces you to use Datatype LONG, or if you try to code some new stuff.
Oracle strongly recommends that you convert LONG into LOB. See
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/sql_elem.htm#45443 for more infos about the datatypes. Create yourself a free account at OTN if you don't already have one.
Please check "Ask Tom", there are many questions/answers with sample code about problems arising when working with LONG Datatype. Simply search for "LONG".

Regards
Manuela Mueller Received on Wed Jan 09 2002 - 16:02:37 CST