Re: Problem with odbc sintax

Jorge Marques wrote:
>
> 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

 oerr ora 907
00907, 00000, "missing right parenthesis" // *Cause:
// *Action:

-- 
Ron Reidy
Oracle DBA