Re: pl/sql help: LAST_ROW_ID question...

In article <968387862.6317.1.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> LAST_ROW_ID to identify the last row processed in
> multi-row update.

Yes. So how do I take a "row id" and determine the actual row?

> So that would mean rowid is referring to tbl1, right?
> tbl1 is the table updated, not tbl2.

I suppose that it would work that way. Either result would be helpful.

> Could you please be more specific with respect to
> 'the subselect fails'

update tbl1 set (a,b,c) = (select a,b,c from tbl2 where tbl1.y = tbl2.z)

The subselct sometimes returns more than 1 row.

When this happens I want to know which row is causing this.

thanks in advance for any tips

-Dan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 08 2000 - 06:51:28 CDT