Simple update doesn't work in Stored Proc
Here is what I have. If I enter this line in Query Browser, name gets set to '1 on the row where companyID = 13.
UPDATE Companies SET Name = '1' WHERE CompanyID = 13
All good. Now if I enter this in as a stored proc (yes, hard coded like that) and then call it from Query Browser, ALL 13 rows in my table, the name changes to '1'.
What am I doing wrong?
TIA
Ralph
Subject
Views
Written By
Posted
Simple update doesn't work in Stored Proc
2092
January 19, 2006 08:57PM
1406
January 20, 2006 02:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.