Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!uunet!acd4!rma
From: rma@acd4.acd.com ( R Matthew Adams      )
Newsgroups: comp.databases
Subject: Error in ORACLE SQL Reference Manual
Keywords: rip-off, shooting themselves in the foot
Message-ID: <1990Jul20.183733.18470@acd4.acd.com>
Date: 20 Jul 90 18:37:33 GMT
References: <1990Jul13.224218.25945@cbnewsm.att.com> <1990Jul16.134342.20026@unhtel.uucp>
Reply-To: rma@acd4.UUCP ( R Matthew Adams      )
Organization: Applied Computing Devices, Inc., Terre Haute, IN
Lines: 24


   In my job I use ORACLE 6.0.26.9.1, and I recently came across what I
believe to be an error in the SQL Language Reference Manual provided by
ORACLE (version 6.0).  

   The one of the syntax diagrams for an UPDATE statement that is
 embedded in PRO*C code shows:

      EXEC SQL [AT dbname] [FOR :host_integer]
      UPDATE table
      SET column1 = { (value) | query }
      [, SET column2 = { (value) | query } ...
      [ WHERE {search_condition|CURRENT OF cursor_name}]

 If the 'SET' directly in front of column2 is left in as specified,
 an error always occured.  If left out, the query was successful.

 Has anyone else ever seen this problem before?  Was it corrected in a 
 later version?  Am I just missing something painfully obvious again?

--------------------------------------------------------------------------
R. Mattew Adams  |  rma@acd4   OR   adamsr@rosevc.rose-hulman.edu
          "What, me worry" - Alfred E. Newman
__________________________________________________________________________