Skip to main content
Participant
March 29, 2008
Question

Oracle Query output erro (MX7)

  • March 29, 2008
  • 1 reply
  • 251 views
Hi

Coldfusion page throwing ODBC error when Oracle (9i) Query executed. No useful error message shown.

Same query gets executed successfully in Oracle Client.


When i use CLOB Column type in my select query error has shown. In the same query i have used substr anticipating that some issues when oracle column type being being CLOB in coldfushion page. It did not work.

Query output returns some html tags also. I guess we need to set some configurations in Coldfusion server. As the same code runs perfectly on the test/production environment.

Pointers are highly appreicated.

Regards
Ram
Beginner in coldfusion Technology
This topic has been closed for replies.

1 reply

Inspiring
March 31, 2008
since you didn't show the query, or the error message, I'll just take a guess and say that you ended your sql with a semi-colon.