Re: Will ROWID change during DB Runing??

From: HansF <News.Hans_at_telus.net>
Date: Tue, 04 Jan 2005 02:57:24 GMT
Message-Id: <pan.2005.01.04.02.56.39.959256@telus.net>

On Tue, 04 Jan 2005 10:41:38 +0800, Grant Zhou wrote:

> The program caused 3 user of 80K user charge error. I have doubts about the
> rowid usage.

ROWID is very efficient if used correctly. However, it is not necessarily the correct technique to access a row, especially if there is an intervening commit.

I agree that you are possibly seeing an example of incorrect usage.

WHen you are ready to go to a supported version of Oracle (either 9i or 10g), add "Effective Oracle By Design" to your list of reading material. (Actually, a lot of the material is relevant for you right now, but I'm encouraging you to move up to a supported version. <g>)

/Hans Received on Mon Jan 03 2005 - 20:57:24 CST