Re: Oracle 7 Deletion Problem
From: Tony Jambu <aaj_at_cmutual.com.au>
Date: Tue, 12 Jul 1994 06:05:19 GMT
Message-ID: <CstCww.A51_at_cmutual.com.au>
> |> ORA-00600: internal error code, arguments: [12838], [], [], [], [], [], [],
> []
> It looks like you're trying to delete from tcmunicipality, not to delete
> tcmunicipality. If that is true, then try the statement with the added
> keyword FROM, to be inserted between 'delete' and 'tcmunicipality'.
Date: Tue, 12 Jul 1994 06:05:19 GMT
Message-ID: <CstCww.A51_at_cmutual.com.au>
In article <2vs3ef$ms6_at_gw.PacBell.COM>, j4hogatt_at_mccoy.srv.PacBell.COM (John
Hogatt) writes:
> In article <1994Jul6.151315.26138_at_logibec.com>, sta_at_logibec.com writes:
.
stuff deleted
. DATE> |> ERROR at line 1:
> |>
> |> SQL> delete tcmunicipality where MUNICIPALITYNAME like 'Mun%';
> |> delete tcmunicipality where MUNICIPALITYNAME like 'Mun%'
> |> *
> |> ORA-00600: internal error code, arguments: [12838], [], [], [], [], [], [],
> []
> It looks like you're trying to delete from tcmunicipality, not to delete
> tcmunicipality. If that is true, then try the statement with the added
> keyword FROM, to be inserted between 'delete' and 'tcmunicipality'.
The FROM is optional. He is deleteing from tcmunicipality. As for the error, sorry cant help.
ta
tony
-- _____ ________ / ____ |Tony Jambu, Database Administrator /_ _ /_ __ / |Colonial Mutual Invest Mgmt,Aust (ACN004021809) /(_)/ )(_/ \_/(///(/_)/_( |EMAIL: TJambu_at_cmutual.com.au \_______/ |PHONE: +61-3-2831639 FAX: +61-3-2831090Received on Tue Jul 12 1994 - 08:05:19 CEST