Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Finding out how many rows were updated?

Finding out how many rows were updated?

From: Paul Tomlinson <rubberducky703_at_hotmail.com>
Date: Fri, 19 Dec 2003 15:07:36 -0000
Message-ID: <brv47p$7pdok$1@ID-116287.news.uni-berlin.de> 





All,



Why does Oracle reject the following SQL as invalid?



UPDATE COMPANIES



SET CONTACT = p_contact,


WHERE COMPANY_ID = p_CompanyID


RETURNING SQL%ROWCOUNT



INTO v_noupdated;



I get "PL/SQL: ORA-00911: invalid character"
I want a way to pass back to my (C++) program the number of rows that this
statement updated.



Your thoughts?
Received on Fri Dec 19 2003 - 09:07:36 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US