David,
with a brief look at your query:
The FROM statement appears to use many tables and there are not commas
after every table name.
Also, the wildcard character in Oracle is % and should be enclosed in
single quotes.

I don't have any OO4O code handy right now but I recall a syntax like:

sqlstr = "select * from emp, dept where emp.deptno = dept.deptno and
emp.ename like 'A%'"

Also, I see more than 3 tables in your FROM clause.

Is this helping any?
Kostis Vezerides