Skip to main content
A
Anonymous
August 16, 2008
Question

Query works in DB GUI, but not in CF

  • August 16, 2008
  • 2 replies
  • 555 views
Hello,

I keep getting a CF error of "invalid character" for the attached query.
Detailed error message: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character

I realize that's an Oracle error code, but the query works in an Oracle db GUI (Toad).

Has anyone experienced this kind of situation?

Thank you.
This topic has been closed for replies.

2 replies

D
Dan_Bracuk
Inspiring
August 17, 2008
Instead of dropping and recreating the temp table, leave it. Delete and replace the records instead.
P
paross1
Participating Frequently
August 18, 2008
I've never tried using DDL in a CFQUERY myself with an Oracle db, but you might try putting the entire statement inline (as in a single line), rather than breaking it out like you did. It would be hard to read, but it might parse better....... just a thought. I've had similar problems with EXECUTE statements within a CFQUERY that worked just fine when I rewrote them with no line breaks, etc.

Phil
D
Dan_Bracuk
Inspiring
August 16, 2008
The semi colon is bad. Some other things might be also.

What did you plan to do with this table anyhow? You might be able to do it without the table.
A
Anonymous
August 17, 2008
Thanks for the reply, Dan. I've tried with and without the semi-colon.

It's for a weekly comparison. Last weeks data is in a table. This weeks data goes into the temp table. I run a comparison query and report results. Then I replace last weeks table with the temp table data and drop the temp table.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices