Re: ORA-00600: internal error code, arguments: [20084], [37832410], [7], [37832410], [7], [], [], []

On Aug 21, 7:44 am, viren.d..._at_gmail.com wrote:
> Can you explain what is this problem ????
>
> I'm using Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production.
>
> When I run PL/SQL Block in SQL +; I have find error like:
>
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [20084], [37832410], [7],
> [37832410], [7], [], [], []
>
> My PL/SQL Block:
> -----------------------------------------
> --- Script By Viren Dave (ACE-SSG) ---
> --- Date : 20-Aug-2007 5:52 PM ---
> --- PQG QA/PFR WP COUNT PL/SQL Script ---
> -----------------------------------------
> SET PAGESIZE 1000
> SET LINE 1000
> -- Variable Declare
> UNDEFINE DATE
> -- Variable Get
> ACCEPT DATE PROMPT "Enter Date (YYYYMMDD) :"
> -- SQL Block
> SELECT
> VQA.EMP_CODE PQA_CODE, E.FIRST_NAME, ROUND(SUM(EP.TIME),2) TIME,
> COUNT(VQA.WP_NO) WPKS,
> MIN(VQA.ALLOT_DATE_TIME) S_TIME, MAX(VQA.RETURN_DATE_TIME) E_TIME
> FROM
> V_PQA_ALLOCATION VQA, EMPPRD EP, EMPLOYEE E
> WHERE
> VQA.STATUS='COMPLETE'
> AND EP.STATUS='COMPLETE'
> AND VQA.JOB_NO=EP.JOB_NO
> AND VQA.BATCH_NO=EP.BATCH_NO
> AND VQA.TASK_CODE=EP.TASK_CODE
> AND VQA.WP_ID=EP.WP_ID
> AND VQA.EMP_CODE=E.EMP_CODE
> AND TO_CHAR(VQA.ALLOT_DATE_TIME, 'YYYYMMDD') = '&DATE'
> GROUP BY
> VQA.EMP_CODE, E.FIRST_NAME
> ORDER BY
> VQA.EMP_CODE, E.FIRST_NAME;
>
> Thanks in advance & Worm Regards,
> Viren Dave
> viren.d..._at_gmail.com

The oracle 600's show some kind of internal error in oracle written code. Something blew up somewhere.

You can work with oracle support and there are several tools to help investigate oracle 600 errors.

If you are running this on a 9.2.0.1 system the odds are pretty good that oracle may have fixed this problem already and that your system is just missing maintenance from oracle.

Of course you need a support contract to be able to download and apply maintenance. Received on Tue Aug 21 2007 - 06:56:27 CDT