get updated records count
Hi
At procedure
....
IF LENGTH(s) >=32 AND LENGTH(s) <=255 THEN
UPDATE users SET sid = s WHERE login = l AND passwd = password(p);
END IF;
....
How get count of updated records?
I can SELECT COUNT(*) FROM users WHERE login = l AND passwd = password(p);
But I think, that is possible to get result of UPDATE records without SELECT. Or I'm wrong?
Subject
Views
Written By
Posted
get updated records count
2264
November 10, 2005 08:05AM
1485
November 11, 2005 06:27PM
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.