Do you have this in workflow?, try to skip ; at the end of the command, Lars
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Koyb P. Liabt Sent: Thursday, September 07, 2006 7:04 PM To: [email protected] Subject: SQL Syntax Hi, I am trying to pass a value into a field on HPD:Helpdesk, and make sure it only updates the current record open. I met with the dba, referenced database guide, and I have this command below, however I am getting failure during SQL operation - invalid character. Does anybody know what is wrong with the syntax below: update T418 set C535478792 = '$Secondary email$' where C1 = '$Case ID+$'; update T418 set C535478792 = "$Secondary email$" where C1 = "$Case ID+$"; update T418 set C535478792 = $Secondary email$ where C1 = $Case ID+$; ARERR [552] Failure during SQL operation to the database : ORA-00911: invalid character ----------------- Forwarded Message: Subj: Re: SQL syntax Date: 9/6/2006 5:04:09 P.M. Eastern Standard Time From: [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) Reply-to: _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
