Hi All,

I am trying to update a set of data - example below:

PROG_TITLE SERIES NO_OF_EPI PROG_TITLE2
seven delaan 4 20 -
sevende laan 1 20 -
seven de laan 2 20 -
sevendelaan 3 20 -

This data was captured incorrectly - the prog_title should be the same
for all (Seven De Laan)
but theres many 'simmillar' variations that were captured, so i used
the following update:

update progs set prog_title2 =
(select prog_title from progs t where soundex(t.prog_title) in
(select soundex(prog_title) from progs where
length(prog_title) =
(select
max(length(prog_title)) from progs))
and length(prog_title) = (select max(length(prog_title)) from progs))


when I run the select part of the statement I get the result im
looking for, but when i include the update part I get the following
error:

ORA-00600: internal error code, arguments: [qctVCO:csform], [0], [0],
[0], [0], [1], [1], [0]

I cant seem to find any simple way to resolve this, i tried Metalink
to look up the error but cant register.

Im using Oracle Express on XP

any suggestions?

> I cant seem to find any simple way to resolve this, i tried Metalink
> to look up the error but cant register.

You'll need to pay for a support contract with Oracle. This will give
you a CSI number which is required to access Metalink. From there, a
quick search of "qctVCO" will show you how to get around your problem.

As with any ORA-600 error, the best course is to work with Oracle
Support. If you do not have a support contract, your next best option is
to use Google to search for the ORA-600 error.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com