I may have been wrong about the ending semi-colon, try it with and without in direct sql action.
On 9/7/06, Mac McMillan <[EMAIL PROTECTED]> wrote:
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