escape syntax error when run on oracle
977539Dec 3 2012 — edited Dec 5 2012hi everyone,
My application uses the below query to update record in Oracle database. When I am running this query, I am getting error like "missing expression" . But this query works fine in Sql server.
UPDATE SFMESSAGE SET PUBLICACCESS=-1,RESPONDBYDATE={ts '2012-11-24 00:00:00'} WHERE PROJECTID=42 AND ( (MESSAGETYPE=21 AND OTHERCOMPTRKINGNUM='519711') OR (MESSAGETYPE=3 AND SERFFTRACKINGNUM='519711') )
Actually this is neither SQL SERVER nor Oracle syntax. That curly braces used for 'RESPONDBYDATE' is actually EScape syntax. If it is supported in sql server, it should be supporten in oracle as well.
Please advise.