Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
ORA-00600: internal error code, arguments: [20084], [37832410], [7], [37832410], [7], [], [], []
ORA-00600: internal error code, arguments: [20084], [37832410], [7], [37832410], [7], [], [], []
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
Received on Tue Aug 21 2007 - 06:44:04 CDT
Original text of this message