Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!uwm.edu!cs.utexas.edu!uunet!mcsun!unido!balu!fifi@cosmo.UUCP
From: fifi@cosmo.UUCP (A.F.Zinser)
Newsgroups: comp.databases
Subject: Re: Error in ORACLE SQL Reference Manual
Keywords: youre right
Message-ID: <5840@balu.UUCP>
Date: 22 Jul 90 11:58:50 GMT
References: <1990Jul20.183733.18470@acd4.acd.com>
Sender: news@balu.UUCP
Reply-To: fifi@cosmo.UUCP (A.F.Zinser)
Organization: CosmoNet, D-3000 Hannover 1, FRG
Lines: 21

In article <> rma@acd4.acd.com ( R Matthew Adams )  writes:
]
]  [about the UPDATE-statement-syntax in Oracle Embedded SQL]
] 
]  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?

No, you're right. I had seen this problem too while using Oracle V6.0.26
and tested it with Oracle V6.0.27 after upgrading: same effect. I assume,
there is a simple typing error in the SQL Language Reference Manual (take
a look on the wrong indent of the fourth line :-). In the Pro*C Users Guide
the Statement is described correctly (Example #5, Page 41).
--
Please Reply-To: fifi%veeble@mcshh.hanse.de || ..!mcsun!unido!mcshh!veeble!fifi

Axel Zinser                                               VOICE: +49 511 699945
             fifi%veeble@mcshh.hanse.de | fifi@cosmo.uucp | fifi@mcshh.hanse.de
                              ...uunet!mcsun!unido!{cosmo!|mcshh![veeble!]}fifi