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

<viren.dave_at_gmail.com> schreef in bericht news:1187696644.018196.195870_at_a39g2000hsc.googlegroups.com...
> 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
>

Just a hinch: is the view V_PQA_ALLOCATION valid?

Worm regards to you too ;-)

Shakespeare Received on Tue Aug 21 2007 - 08:00:46 CDT