Oracle/JDBC driver concatenation problem - help!

Hi there,

I'm using the Oracle/JDBC driver oracle.jdbc.driver.OracleDriver and executing the following statement:

SELECT
C.VALIDATION_TYPE || ' ' || C.PROVISION_MODE || '-' || C.STYLE_SEQUENCE 'SERVICE_STYLE'
FROM
SERVICE A, SERVICE_CATEGORY B, SERVICE_STYLE C WHERE
A.SERVICE_CATEGORY_ID = B.SERVICE_CATEGORY_ID AND A.SERVICE_STYLE_ID = C.SERVICE_STYLE_ID When I test this with the ODBC driver in MS Query for example, everything works fine: the columns are concatenated into a new column SERVICE_STYLE for display.

However with JDBC I get the following error:

Message: ORA-00923: FROM keyword not found where expected

Is this a know limitation with JDBC? Can I not concatenate this way?

Any help would greatly appreciated!!

Thanks,

Dan

--
Daniel Kirkdorffer
Sr. Consultant, Syllogistics, LLC.
Email: dan.kirkdorffer 'at' syllogistics 'dot' com
       daniel.kirkdorffer 'at' attws 'dot' com
Web:   http://www.syllogistics.com/
       http://members.aol.com/dankirkd/
Visual Cafe Tips:
       http://members.aol.com/dankirkd/vcafe.htm