не знаю тот ли раздел, если что - переместите.
Есть ошибка
| Цитата |
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;
|
Подскажите плиз, в чем может быть проблема . |
