Re: Finding out how many rows were updated?

From: Paul Tomlinson <rubberducky703_at_hotmail.com>
Date: Fri, 19 Dec 2003 15:41:55 -0000
Message-ID: <brv684$80len$1@ID-116287.news.uni-berlin.de>

Yeah, yeah, cut and paste error.

That is not the problem.

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1071848161.353211_at_yasure...
> Paul Tomlinson wrote:
>
> > 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?
>
> SET CONTACT = p_contact,
>
> To start with. What is the comma supposed to do?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Fri Dec 19 2003 - 09:41:55 CST