tablename is an invalid object

If you have configured Oracle datasource there for sql query then you can use below short cfquery example to check required datasource user & its permission to run query through CF server:-

--------

<cfquery name="query1" datasource="dsname">

select user from dual

</cfquery>

Query Result:

<cfdump var="#query1#">

-----------------

If it gives cfdump result then your datasource user are corrert so you will need to further check for your table schema.

When you say you can query the table through SQL, do you mean using an external tool from ColdFusion?  Could it be a permissions issue with the account you configured in CF Admin for that datasource (which might be a different account from the one you use in the external tool)?

-Carl V.

If synonyms are not established, try prepending the schema name to the table (schema.table).

^_^