Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: ORACLE: invalid SQL statement
12-05-2012, 03:27 PM #1
- Join Date
- Apr 2012
- St. Louis, MO, USA
- Thanked 101 Times in 101 Posts
ORACLE: invalid SQL statement
I'm trying to update one column in one table, and I'm getting an "invalid SQL statement" error message from the Oracle database. Could someone please tell me what I'm doing incorrectly?
UPDATE [schema].[table] SET status = 'Working' WHERE create_date = '2012-12-05 08:50:55'
UPDATE: I had code remarked with /* and */ in front of the query. I thought it would be ignored, but apparently it was enough to make the db server think that there was invalid SQL present.
Last edited by WolfShade; 12-05-2012 at 04:32 PM.^_^
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".