CFMX- Oracle Error

[Ssschmidt]

This maybe more of a syntax error but I am having trouble connecting to an Oracle table. The connection is returning rows from Dreamweaver and the connection is verified on the adminstrators side....
The error I am getting is ...

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Does anyone know if this syntax is correct
It is an Oracle database

<cfquery name="RsCustomer" datasource="#Application.datasource#">

SELECT OUTLN.USERS.LOGIN_NAME, OUTLN.USERS.USER_ID, OUTLN.USERS.TYPE_ID
as Typeid, OUTLN.USERS.FIRST_NAME as First, OUTLN.USERS.SECOND_NAME as Second,
OUTLN.USERS.BUSINESS_SECTION as Busid, OUTLN.USERS.COMPANY_NAME as Compname
FROM OUTLN.USERS WHERE OUTLN.USERS.TYPE_ID>-1
AND OUTLN.USERS.LOGIN_NAME='#Userid#'
and OUTLN.USERS.PASSWORD = '#form.pwd#'
</cfquery>

 

[sunil]

I will like to know have you generated any ticket releated to this issue, and if you generated the ticket releated to this issue did you got any response from our system support team ?

By the way Explanation of error that you are getting is as below

ORA-00942 table or view does not exist

Cause: The table or view entered does not exist, a synonym that is not allowed here was used, or a view was referenced where a table is required. Existing user tables and views can be listed by querying the data dictionary. Certain privileges may be required to access the table. If an application returned this message, the table the application tried to access does not exist in the database, or the application does not have access to it.

Action: Check each of the following:

the spelling of the table or view name.
that a view is not specified where a table is required.
that an existing table or view name exists.
Contact the database administrator if the table needs to be created or if user or application privileges are required to access the table.

Also, if attempting to access a table or view in another schema, make certain the correct schema is referenced and that access to the object is granted.

Please feel free to contact us if you need any support.