Re: Update more than one table in cursor

From: <un2000_at_my-deja.com>
Date: Wed, 09 Jun 1999 23:31:07 GMT
Message-ID: <7jmtfr$274$1@nnrp1.deja.com>

You should always get an 'Invalid Rowid' ora-01410 error - if you are trying to update columns in 2 different tables with a for update cursor - if I understand your question correctly. Hope this helps.

In article <01beb2b6$dcc76680$e401010a_at_FRANK>, "Frank Calfo" <fcalfo_at_psateam.com> wrote:
> Can I create an updateable cursor that selects from two tables and
update
> columns in both tables?
>
> The procedure which includes this compiles without error, but when I
run it
> I get
> ORA-00600 internal error code, arguments: [2845], [0], [20], [0], [],
[],
> [], []
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 09 1999 - 18:31:07 CDT