It looks like your running this from ARS. Only the first line is valid. Also, you need to perform a commit. If you must run this, you need to execute an anomynous pl/sql as a direct sql action
Try this: do update T418 set C535478792 = '$Secondary email$' where C1 = '$Case ID+$'; commit; end DON'T NEED THE ENDING SEMI-COLON!, ARS will add this for you. ==Mac On 9/7/06, Frank Caruso <[EMAIL PROTECTED]> wrote:
** Not sure where you ar running this from - Remedy, oracle, sqlplus... but it is complaining about the semi-colon. If you are in Remedy I think you can remove it. On 9/7/06, Koyb P. Liabt <[EMAIL PROTECTED]> wrote: > 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 > -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org