VPF::Error: ORA-00997: illegal use of LONG datatype - Форум программистов

Samotnik

Дата 24.3.2010, 12:52 (ссылка)

(нет голосов)

Загрузка ...

Super star !

Профиль
Группа: Awaiting Authorisation
Сообщений: 7192
Регистрация: 4.11.2006
Где: Минск City

Репутация: нет
Всего: 191

не знаю тот ли раздел, если что - переместите.
Есть ошибка

Цитата

Error: ORA-00997: illegal use of LONG datatype

в вот таком большом при большом Селекте

Код


select distinct t0.ACTUALAMOUNT as f1,t0.ADBOOKINGDEADLINEID as f2,t0.COMMONCOMMENT as f3,t0.CONTACTPERSONCOMMUNICATION 
as f4,t0.CONTACTPERSONNAME as f5,t0.CREATIONDATE as f6,t0.CREATIONUSER as f7,t0.EDITIONSLONG as f8,t0.EDITORIALCOMMENT 
as f9,t0.EDITORIALOFFICE as f10,t0.EVENTDATEFROM as f11,t0.EVENTDATETO as f12,t0.EVENTTIME as f13,t0.FROMTECHNIQUE as f14,t0.ID 
as f0,t0.MODIFICATIONCOMMENT as f16,t0.MODIFICATIONDATE as f15,t0.MODIFICATIONUSER as f17,t0.OPTIONONE as f19,t0.OPTIONTHREE 
as f18,t0.OPTIONTWO as f21,t0.OPTLOCKVERSION as f49,t0.ORDERING as f20,t0.PAGEINFORMATION as f23,t0.PARENTTHEMESUPPLPARTID 
as f22,t0.PLANNEDAMOUNT as f25,t0.PLANNEDHEIGHT as f24,t0.PLANNEDNOOFCOLUMNS as f27,t0.PLANNEDNOOFPAGES 
as f26,t0.PLANNEDWIDTH as f29,t0.PLANNINGDEADLINEID as f28,t0.PREVIEWPERSONCOMMUNICATION as f32,t0.PREVIEWPERSONNAME 
as f33,t0.PREVIEWSALESREPID as f30,t0.RATIOTEXT2AD as f31,t0.RELATEDADCLASSEMPTY as f36,t0.RELATEDADCLASSID 
as f37,t0.RESPONSIBLEEDITORJOURNALISTID as f34,t0.RESPONSIBLEPERSONID as f35,t0.SALESREPID as f40,t0.SHORTNAME 
as f41,t0.STATUSFORTSD as f38,t0.STATUSOFEDITORIALTEXT as f39,t0.THEMESUPPLPARTID as f44,t0.THEMESUPPLTYPE 
as f42,t0.TOTECHNIQUE as f43,t0.TRANSFERTYPEID as f48,t0.VALIDADTYPES as f47,t0.VALIDCOLOURTYPES 
as f46,t0.VENUE as f45 from THEMESUPPLDEFINITION t0 where THEMESUPPLPARTID = 147842748 order by f0 ASC;

Подскажите плиз, в чем может быть проблема .

Это сообщение отредактировал(а) Samotnik - 24.3.2010, 12:52

LSD

Дата 24.3.2010, 13:17 (ссылка)

(голосов:1)

Загрузка ...

Leprechaun Software Developer

Профиль
Группа: Модератор
Сообщений: 15718
Регистрация: 24.3.2004
Где: Dublin

Репутация: 18
Всего: 538

Цитата

Restrictions on DISTINCT and UNIQUE Queries These types of queries are subject to the following restrictions:
* When you specify DISTINCT or UNIQUE, the total number of bytes in all select list expressions is limited to the size of a data block minus some overhead. This size is specified by the initialization parameter DB_BLOCK_SIZE.
* You cannot specify DISTINCT if the select_list contains LOB columns.

--------------------

Disclaimer: this post contains explicit depictions of personal opinion. So, if it sounds sarcastic, don't take it seriously. If it sounds dangerous, do not try this at home or at all. And if it offends you, just don't read it.

Samotnik

Дата 24.3.2010, 13:43 (ссылка)

(нет голосов)

Загрузка ...

Super star !

Профиль
Группа: Awaiting Authorisation
Сообщений: 7192
Регистрация: 4.11.2006
Где: Минск City

Репутация: нет
Всего: 191

LSD, Danke ! smile

0 Пользователей читают эту тему (0 Гостей и 0 Скрытых Пользователей)
0 Пользователей:
« Предыдущая тема \| Oracle \| Следующая тема »