RE: UPDATE Results

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Tue, 21 May 2002 10:03:45 -0800
Message-ID: <F001.0046636E.20020521100345@fatcity.com>

If you are within a C-type program, the SQLCA contains a field that contains the number of rows updated. Look at the Application Developer's Guide for more information.  

Thank You  

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:                   (248) 865-4350
Mobile:                  (248) 408-2918
Email:                      Stephen.Karniotis_at_Compuware.com
Web:                        www.compuware.com
 

-----Original Message-----
Sent: Tuesday, May 21, 2002 1:27 PM
To: Multiple recipients of list ORACLE-L  

BM__MailAutoSigIs there a way to access 'something' that would denote if any rows were updated?
Feedback lets you set up how many rows will be effected before a count is returned, but WHERE is this number coming from? I have found a 'Returning' clause of the update statement, but I don't really want a value returned, just how many rows were affected. We have a situation where we want to know if an update statement actually updated any rows or in fact did not find a row that met the condition. SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming from?
Thanks you for your help.
Laura

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 21 2002 - 13:03:45 CDT