Home > IT Answers > Oracle > Filemaker Pro 9 ODBC ORA-00936 error
Ezzyrider
35 pts.
 Filemaker Pro 9 ODBC ORA-00936 error
ORA-00936
I can see all of my tables in an Oracle dbase. For two of them, I can see the actual values. On another table, I can see the fields but the actual values return with an
Software/Hardware used:
ASKED: July 23, 2009  3:33 PM
UPDATED: July 23, 2009  7:05 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

the values return with an

Ezzyrider
 35 pts.
 

Actual Oracle ORA-00936: error

Ezzyrider
 35 pts.
 

ORA-00936 means incorrect syntax on a query.
How do you get the values from the database ? do you issue an SQL query, or is it being generated by FileMaker ?

carlosdl
 63,535 pts.
 

it’s an existing table. I’m not writing an SQL query at this point. I just want to see the data in that table.
I don’t know how I’m getting a syntax error (I do understand that’s what this is). I haven’t written anything.

Ezzyrider
 35 pts.
 

I have never used filemaker, but I guess there is something wrong with the query it is sending to Oracle to get the data, or with the ODBC driver.

Has this table something different than the others ? maybe something special in the table or column names ?

carlosdl
 63,535 pts.