In Oracle 8i, the syntax "LEFT OUTER JOIN" is not supported. It is supported in Oracle 9i.
If I try to find some records using something like this on model called Work, I get an error: :include => [:project, :function, :account]
The error is: OCIError: ORA-00933: SQL command not properly ended: SELECT count(DISTINCT work.workno) AS count_all FROM work LEFT OUTER JOIN project ON project.projectno = work.projectno LEFT OUTER JOIN function ON function.functionno = work.functionno LEFT OUTER JOIN account ON account.accountno = work.accountno WHERE (developerid = 'iwz')
If you take a look at the query, it is using syntax not supported by Oracle 8i. SELECT count(DISTINCT work.workno) AS count_all FROM work LEFT OUTER JOIN project ON project.projectno = work.projectno LEFT OUTER JOIN function ON function.functionno = work.functionno LEFT OUTER JOIN account ON account.accountno = work.accountno WHERE (developerid = 'iwz')
Here is how the SQL should be formatted:
SELECT count(DISTINCT work.workno) AS count_all FROM work, project, function, account WHERE (developerid = 'iwz') and project.projectno(+) = work.projectno and function.functionno(+) = work.functionno and account.accountno(+) = work.accountno
Does anyone know of a workaround, patch, or anything regarding this?
Thanks! Ian.