ColdFusioning.com
Pronunciation \kold-fy-zhn-ing\ Noun: The actions of one that writes ColdFusion.

Please check out my new site: http://ja.mesbrown.com/

ColdFusion and Oracle Weird Database Error: ORA-01722: invalid number

I recently made an update to a table and start receiving a weird error:

view plain print about
1[Macromedia][Oracle JDBC Driver][Oracle]ORA-01722: invalid number

even though the SQL hadn't changed and I had only added a column to the database. Well, it turns out that cfqueryparam and ColdFusion do some weird caching that was causing the error. If changed the query (i.e. change the order of the WHERE statements (which didn't change the results)), the error went away.

Truly a weird error.

TweetBacks

Comments

CFING, a semi-colon at the end of your query would have "done the trick"? FREDTERP

# Posted By FREDTERP | 12/31/09 11:38 PM

It actually required one of the variables to be changed. I think it has to do with cfqueryparam's caching.

# Posted By James Brown | 1/1/10 5:24 AM

Recent Comments

RSS

Subscribe