One Star

ORA:00933 SQL Command Not Properly Ended / Oracle 8.1.7 / TOP 3.2

Hi
I use TOP 3.2 with Oracle 8.1.7 database.
I created Rule which includes JOIN between a table and a view in the same oracle account. The generated SQL for the rule is :
SELECT COUNT(*) FROM "ADCO_GLOBAL"."WELL_DIR_SRVY_PTS" JOIN "WELL_DIR_SRVY_PTS_MAX_ANGLE" ON ( "WELL_DIR_SRVY_PTS". "UWI" = "WELL_DIR_SRVY_PTS_MAX_ANGLE". "UWI" ) JOIN "WELL_DIR_SRVY_PTS_MAX_ANGLE" ON ( "WELL_DIR_SRVY_PTS". "DIR_SRVY_ID" = "WELL_DIR_SRVY_PTS_MAX_ANGLE". "DIR_SRVY_ID" ) JOIN "WELL_DIR_SRVY_PTS_MAX_ANGLE" ON ( "WELL_DIR_SRVY_PTS". "DEVIATION_ANGLE" = "WELL_DIR_SRVY_PTS_MAX_ANGLE". "MAX_DEVIATION_ANGLE" ) WHERE (uwi like 'HU%') AND (uwi like '%H' and deviation_angle > 86 )

the error message is
ORA:00933 SQL Command Not Properly Ended

I think the generated SQL can not be executed on my oracle 8.1.7. I tried to used other versions of JDBC drivers but still have the same problem.
please help me to solve this.
thanks
Arafat

1 REPLY
Employee

Re: ORA:00933 SQL Command Not Properly Ended / Oracle 8.1.7 / TOP 3.2

Hi Arafat,
unfortunately, as far as I know, the generated query is not compliant with Oracle 8i as Oracle 8i does not support the ANSI/ISO SQL "JOIN" keyword.
See http://www.oracle-base.com/articles/9i/ANSIISOSQLSupport.php
Up to now, we do not support this version of Oracle database. Nevertheless you can create a bugtracker issue at http://www.talendforge.org/bugs/my_view_page.php
and ask for support of your database.