Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00600: internal error code, arguments: [20084], [37832410], [7], [37832410], [7], [], [], []

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

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Tue, 21 Aug 2007 13:26:16 -0500
Message-ID: <46cb2246$0$16328$88260bb3@free.teranews.com>


viren.dave_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.dave_at_gmail.com
>

As others have said, the ORA-600 error is an untrapped Oracle error. The best source of fixing these errors is an Oracle Support contract. If you do not want to pay for a support contract, then your next best option is to do a Google search for "ora 600 20084". This will bring up lots of hits and most of them will tell you of bugs which are fixed in various patchsets. So you'll need to apply a patchset to fix the problem. Unfortunately, that means you will need to pay for Oracle Support...

Cheers,
Brian

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

Brian Peasland
dba_at_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
Received on Tue Aug 21 2007 - 13:26:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US