executeQuery( "SELECT * FROM \"activity\";" )
returns "ORA-00911: invalid character (in oracle.jdbc.driver.DatabaseError)"
The code worked before with mySQL and I tried to make it portable with an Oracle database.
For some reason, quotations are treated as invalid characters when it is executed by JAVA.
However, I executed that query (without the "\") from the SQL Command Line, it works. Without the quotations, it return "tables or views does not exist" (different output from the output with quotations: no rows selected).
I don't know how to perform a query if quotations are forbidden...
Any advices/help appreciated.
returns "ORA-00911: invalid character (in oracle.jdbc.driver.DatabaseError)"
The code worked before with mySQL and I tried to make it portable with an Oracle database.
For some reason, quotations are treated as invalid characters when it is executed by JAVA.
However, I executed that query (without the "\") from the SQL Command Line, it works. Without the quotations, it return "tables or views does not exist" (different output from the output with quotations: no rows selected).
I don't know how to perform a query if quotations are forbidden...
Any advices/help appreciated.
