Problem with odbc sintax

From: Jorge Marques <JMarques_at_milenio3.pt>
Date: Wed, 22 May 2002 12:42:48 +0100
Message-ID: <ptLG8.230$%47.1162386@newsserver.ip.pt>

I don't know if you can help me, but the situation is:

I have a little problem with my instruction sql above

SELECT DISTINCT EMP_EMPLOYEE.Id AS Id, EMP_EMPLOYEE.EmployeeId,

EMP_EMPLOYEE.Code, EMP_EMPLOYEE.Password, EMP_EMPLOYEE.Name AS Name,
EMP_EMPLOYEE.HierarchyCode, EMP_EMPLOYEE.ShortName, EMP_EMPLOYEE.JobTitle,
EMP_EMPLOYEE.Sex, EMP_EMPLOYEE.Birthday, EMP_EMPLOYEE.Admission,
EMP_EMPLOYEE.Rescission, EMP_EMPLOYEE.CalendarId, EMP_EMPLOYEE.PDCProfileId,
EMP_EMPLOYEE.CardId, EMP_EMPLOYEE.DepartmentId, EMP_EMPLOYEE.List1Id,
EMP_EMPLOYEE.List2Id, EMP_EMPLOYEE.List3Id, EMP_EMPLOYEE.List4Id,
EMP_EMPLOYEE.List5Id, EMP_EMPLOYEE.List6Id, EMP_EMPLOYEE.List7Id,
EMP_EMPLOYEE.List8Id, EMP_EMPLOYEE.List9Id, EMP_EMPLOYEE.List10Id,
EMP_EMPLOYEE.Address, EMP_EMPLOYEE.ZipCode, EMP_EMPLOYEE.City,
EMP_EMPLOYEE.Region, EMP_EMPLOYEE.Country, EMP_EMPLOYEE.MobilePhone,
EMP_EMPLOYEE.HomePhone, EMP_EMPLOYEE.Email, EMP_EMPLOYEE.ExtensionPhone,
EMP_EMPLOYEE.Pin, EMP_EMPLOYEE.Notes, EMP_LIST1.Name AS List1Name,
EMP_LIST2.Name AS List2Name, EMP_LIST3.Name AS List3Name, EMP_LIST4.Name AS

List4Name, EMP_LIST5.Name AS List5Name, EMP_LIST6.Name AS List6Name, EMP_LIST7.Name AS List7Name, EMP_LIST8.Name AS List8Name, EMP_LIST9.Name AS List9Name, EMP_LIST10.Name AS List10Name, EMP_PDC_PROFILE.Name AS PDCProfileName, EMP_CALENDAR.Name AS CalendarName, EMP_DEPARTMENT.Name AS DepartmentName, EMP_EMPLOYEE.HistoryStartDate AS HistoryStartDate, EMP_EMPLOYEE.HistoryEndDate AS HistoryEndDate, EMP_EMPLOYEE.HistoryOperation AS HistoryOperation, EMP_EMPLOYEE.HistoryWho AS HistoryWho, EMP_EMPLOYEE.HistoryWhen AS HistoryWhen FROM {oj EMP_DEPARTMENT RIGHT OUTER JOIN (EMP_PDC_PROFILE RIGHT OUTER JOIN (EMP_LIST9 RIGHT OUTER JOIN (EMP_LIST8 RIGHT OUTER JOIN (EMP_LIST7 RIGHT OUTER JOIN (EMP_LIST6 RIGHT OUTER JOIN (EMP_LIST5 RIGHT OUTER JOIN (EMP_LIST4 RIGHT OUTER JOIN (EMP_LIST3 RIGHT OUTER JOIN (EMP_LIST2 RIGHT OUTER JOIN (EMP_LIST10 RIGHT OUTER JOIN (EMP_LIST1 RIGHT OUTER JOIN (EMP_CALENDAR RIGHT OUTER JOIN

EMP_EMPLOYEE ON EMP_CALENDAR.Id = EMP_EMPLOYEE.CalendarId) ON EMP_LIST1.Id =
EMP_EMPLOYEE.List1Id) ON EMP_LIST10.Id = EMP_EMPLOYEE.List10Id) ON
EMP_LIST2.Id = EMP_EMPLOYEE.List2Id) ON EMP_LIST3.Id = EMP_EMPLOYEE.List3Id)

ON EMP_LIST4.Id = EMP_EMPLOYEE.List4Id) ON EMP_LIST5.Id = EMP_EMPLOYEE.List5Id) ON EMP_LIST6.Id = EMP_EMPLOYEE.List6Id) ON EMP_LIST7.Id = EMP_EMPLOYEE.List7Id) ON EMP_LIST8.Id = EMP_EMPLOYEE.List8Id) ON EMP_LIST9.Id = EMP_EMPLOYEE.List9Id) ON EMP_PDC_PROFILE.Id = EMP_EMPLOYEE.PDCProfileId) ON EMP_DEPARTMENT.Id = EMP_EMPLOYEE.DepartmentId} WHERE (Code = '2332') AND (EMP_EMPLOYEE.HistoryOperation IN ('U', 'I') AND EMP_EMPLOYEE.HistoryStartDate <= {fn NOW()} AND (EMP_EMPLOYEE.HistoryEndDate
> {fn NOW()} OR EMP_EMPLOYEE.HistoryEndDate Is NULL) AND
(EMP_EMPLOYEE.Rescission Is NULL OR EMP_EMPLOYEE.Rescission > {fn NOW()})) AND (7=7) ORDER BY EMP_EMPLOYEE.Code

I use the odbc syntax with oracle drive 8.1.76.

I don't know what's happen but the oracle give me the error ora-00907.

Tanks

Jorge Marques Received on Wed May 22 2002 - 06:42:48 CDT