Re: select on LONG!

From: Jurij Modic <jmodic_at_src.si>
Date: Wed, 01 Sep 1999 21:22:10 GMT
Message-ID: <37cd95ec.108965@news.siol.net>

On Wed, 01 Sep 1999 10:14:15 +0200, Doktor <doktor_at_post.pl> wrote:

>It's impossibile to select LONG datatype in SQL*Plus. If you selecting
>LONG column into variable, remember, that you can use only 32K of data
>for variables.

You are wrong on LONG and SQL*Plus - there is no restriction on selecting LONG columns in SQL*Plus. The only catch is that by default SQL*Plus shows only first 80 characters of LONG column. So Michel's suggestion on setting SQL*Plus's parameter LONG to some larger value was totally correct.

Regards,

Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Wed Sep 01 1999 - 16:22:10 CDT