confounding ORA-00933 error

[trespitt]

consider the following query, which runs perfectly fine in sql developer:

select * from user2.cust_comms x, user2.cust_info y where x_id=y_id and x_age!=y_age and second_id>900

please note that x_ is not a mistake; I don't need to use the dot operator because these are unique columns.

This is such a simple query, with very brief results. the full error is:

'mismatch' rs-error: Error in .oci.SendQuery(conn, statement, data = data, prefetch = prefetch, : ORA-00933: SQL command not properly ended\n\n"
Error in .oci.Disconnect(conn) : invalid connection `

I would love to know if this error is on my end (r env, os, something like that), or with Roracle. thanks for all your hard work!

[gaborcsardi]

Hi, this is a read only mirror of CRAN, please see the package authors in the DESCRIPTION file. Look for Maintainer, BugReports and URL. Thanks!