Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I use CTEs without getting java.sql.SQLSyntaxErrorException: ORA-00928: missing SELECT keyword?

SMerrill8Jul 8 2019 — edited Jul 10 2019

I have a query which works in Toad using the Windows 64-bit instant client v 12.2.0.1, but does not work in Splunk using the ojdbc-full.tar 12.1.0.1 Oracle JDBC Thin driver :

WITH X as (SELECT ...)

, Y as (SELECT ... FROM X ...)

SELECT ... FROM Y

I get the ORA-00928: missing SELECT keyword error in the titlebar.

However, a simpler select statement works fine in Splunk.

Any thoughts?
Comments
Post Details
Added on Jul 8 2019
5 comments
904 views