ORA-00904: "DOMAINELEMENT"."EXTENTION": invalid identifier
From: sandyb <member_at_dbforums.com>
Date: Tue, 24 Dec 2002 09:17:04 +0000
Message-ID: <2315219.1040721424_at_dbforums.com>
DocumentElement.documentElementId,
Document.documentId,
Document.name as documentName,
DocumentElement.valueText,
DocumentElement.valueLargeText,
DocumentElement.userIdChanged as userIdChanged, DocumentTypeElement.domainId,
DocumentTypeElement.label,
DocumentElement.domainElementId,
Template
join DocumentType on documentType.documentTypeId = template.documentTypeId
join Document on Document.documentTypeId = DocumentType.documentTypeId and Document.tsStart < SYSDATE and ( Document.tsEnd is null or Document.tsEnd > SYSDATE)
join DocumentVersion on documentVersion.documentVersionId = Document.publishingDocumentVersionId
and DocumentVersion.documentId = Document.documentId left outer join TemplateDocumentTypeElement on TemplateDocumentTypeElement.templateId = template.templateId left outer join DocumentTypeElement on DocumentType.documentTypeId = DocumentTypeElement.documentTypeId
and DocumentTypeElement.documentTypeElementId = templateDocumentTypeElement.documentTypeElementId left outer join Domain on Domain.domainId = documentTypeElement.domainId
where
(template.templateId = 2)
and (((Document.tsStart <= '2002-12-23 11:08:28.0' and Document.tsEnd is null)
>='2002-12-23 11:08:28.0' ))
or (Document.tsStart >= '2002-12-23 11:08:28.0')) order by Document.defaultOrder, Document.tsstart desc , Document.documentId, TemplateDocumentTypeElement.displayOrder;
Date: Tue, 24 Dec 2002 09:17:04 +0000
Message-ID: <2315219.1040721424_at_dbforums.com>
Hi there,
I have the folowing huge query. I get the error message :
ERROR at line 29:
ORA-00904: "DOMAINELEMENT"."EXTENTION": invalid identifier
The query:
select
DocumentTypeElement.documentTypeId as documentTypeId, DocumentTypeElement.documentTypeElementId as documentTypeElementId, DocumentTypeElement.name as name, DocumentTypeElement.isMandatory,
DocumentElement.documentElementId,
Document.documentId,
Document.name as documentName,
DocumentElement.valueText,
DocumentElement.valueLargeText,
DomainElement.valueText as domainElementValueText, DomainElement.valueLargeText as domainElementValueLargeText, DomainElement.extention as domainElementExtention, DocumentElement.tsCreated as tsCreated, DocumentElement.userIdCreated as userIdCreated,DocumentElement.tsChanged as tsChanged,
DocumentElement.userIdChanged as userIdChanged, DocumentTypeElement.domainId,
DocumentTypeElement.label,
DocumentElement.domainElementId,
Domain.domainId, Domain.length as Length, Domain.name as domainName, Domain.datatypeId as dataTypeId, Domain.hasDomainValues, DomainElementDomain.length as domainElementDomainLength,DomainElementDomain.name as domainElementDomainname, DomainElementDomain.datatypeId as domainElementDomainType, DomainElement.extention as domainElementDomainExtention from
Template
join DocumentType on documentType.documentTypeId = template.documentTypeId
join Document on Document.documentTypeId = DocumentType.documentTypeId and Document.tsStart < SYSDATE and ( Document.tsEnd is null or Document.tsEnd > SYSDATE)
join DocumentVersion on documentVersion.documentVersionId = Document.publishingDocumentVersionId
and DocumentVersion.documentId = Document.documentId left outer join TemplateDocumentTypeElement on TemplateDocumentTypeElement.templateId = template.templateId left outer join DocumentTypeElement on DocumentType.documentTypeId = DocumentTypeElement.documentTypeId
and DocumentTypeElement.documentTypeElementId = templateDocumentTypeElement.documentTypeElementId left outer join Domain on Domain.domainId = documentTypeElement.domainId
where
(template.templateId = 2)
and (((Document.tsStart <= '2002-12-23 11:08:28.0' and Document.tsEnd is null)
or (Document.tsStart <= '2002-12-23 11:08:28.0' and Document.tsEnd
>='2002-12-23 11:08:28.0' ))
or (Document.tsStart >= '2002-12-23 11:08:28.0')) order by Document.defaultOrder, Document.tsstart desc , Document.documentId, TemplateDocumentTypeElement.displayOrder;
I am running Orcale 9i
What's seems to be the problem.
The field DomainElement.extention does exist.
Friendly regards,
Sandy
-- Posted via http://dbforums.comReceived on Tue Dec 24 2002 - 10:17:04 CET