Re: Strange Oracle Internal Error

A copy of this was sent to Syed Faisal Shah <faisal_at_cyber.net.pk> (if that email address didn't require changing) On Mon, 21 Jun 1999 12:18:30 +0500, you wrote:

>Hi
>
>ORA-600 Error is not good news.
>
>The oracle database is corrupt and need to be reinstalled. You will see
>that the export/import utilities will also not function.
>

no it does not. ora-600 means some internal error has happened. It is rarely linked to corruption. ora-600 means you should call support. the database is not corrupt.

>Regards
>Faisal
>
>a_andy_at_my-deja.com wrote:
>
>> Hi,
>>
>> I am trying to execute a procedure which calls multiple procedures. e.g
>>
>> All of these procedures use a large rollback segment and I use a 'SET
>> TRANSACTION USE ROLLBACK....' in beginning and 'COMMIT' at the end of
>> these.
>>
>> procedure main_proc
>> begin
>> select column into x from table where ...;
>> if x = .. then
>> a_procedure;
>> b_procedure;
>> c_procedure;
>> d_procedure;
>> end if;
>> end main_proc;
>>
>> When I execute this procedure in production database it executes
>> without any errors. But when I try to execute this in the test database
>> (where it used to work earlier), I get an internal oracle error. I am
>> pasting the error below :
>>
>> ORA-00600: internal error code, arguments: [4200], [], [], [], [], [],
>> [], []
>> ORA-06512: at "a_procedure", line 25
>> ORA-06512: at "main_proc", line 5
>>
>> I do not get this error and it works if, I comment the 'SET TRANSACTION
>> USE ROLLBACK....' in the first procedure i.e 'a_procedure' although I
>> still have 'set trans...' in all other procedures.
>>
>> I tried to comment the 'a_procedure' in main_proc and still it gives
>> the same error for 'b_procedure'.
>>
>> So, it gives me an error if the first procedure called from main_proc
>> has a 'SET TRANSACTION USE ROLLBACK....' and works if I remove that
>> from the first one.
>>
>> It seems there is a bug reported in Oracle 8.05(BUG# 285843), related
>> to 'SET TRANS..'. But as I mentioned earlier the same procedure works
>> in PROD database.
>>
>> If anyone has any info on this ...please help..
>>
>> Thanks.
>>
>> Sent via Deja.com http://www.deja.com/
>> Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 21 1999 - 07:02:47 CDT