Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00600: internal error code due to arguments
icon4.gif  ORA-00600: internal error code due to arguments [message #269227] Fri, 21 September 2007 04:52 Go to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Hi,

I am getting this error message on My QC Env. The same is working fine on Dev Env.

I am not able to Simulate this issue..

ERROR:

"Error while loading check_loc_state_pol_state array in procedure ORA-00600: internal error code due to arguments: []"

Beloew is the Part of Code that application is calling.

PROCEDURE check_loc_state_pol_state
IS
mmy_edit_passed_flag VARCHAR2(1);
mmy_loc_state entity_address_master.enty_state%TYPE;

TYPE policy_locations_arr is TABLE of auto_billing_objects.policy_locations_cur%ROWTYPE INDEX BY BINARY_INTEGER;

cmn_location_arr policy_locations_arr;
mmy_count NUMBER(4);

BEGIN
mmy_edit_passed_flag := 'Y';
diag.set_diagnostics_flag;

cmn_location_arr.DELETE;
mmy_count := 0;

FOR mmy_pl_cur IN auto_billing_objects.policy_locations_cur(auto_billing.cmn_session_no)
LOOP
mmy_count := auto_billing_objects.policy_locations_cur%ROWCOUNT;
cmn_location_arr(mmy_count) := mmy_pl_cur;
diag.pr('mmy_pl_cur' || mmy_pl_cur);
END LOOP;

FOR i IN 1..cmn_location_arr.COUNT
LOOP
IF cmn_location_arr(i).pl_group_code = 'LOCATION'
AND cmn_location_arr(i).pl_begin_date >= auto_billing.cmn_policy_begin_date
AND NVL(cmn_location_arr(i).pl_end_date,auto_billing.cmn_policy_end_date) <= auto_billing.cmn_policy_end_date
THEN
BEGIN
SELECT enty_state
INTO mmy_loc_state
FROM entity_address_master
WHERE enty_group_code = 'LOCATION'
AND enty_master_code = cmn_location_arr(i).pl_master_code;
diag.pr('mmy_loc_state' || mmy_loc_state);

EXCEPTION
WHEN NO_DATA_FOUND THEN
auto_billing.cmn_error_code := 'ERATE-7031';
auto_billing.cmn_error_mesg :='check_loc_state_pol_state';
auto_billing.ins_error_log(auto_billing.cmn_error_code,auto_billing.cmn_error_mesg,'check_loc_state_pol_state',
'abo_edit_check_objects');
auto_billing.cmn_success_failure :='99';
RETURN;
END;

IF auto_billing.cmn_state_code != mmy_loc_state THEN
diag.pr('mmy_loc_state' || mmy_loc_state);
diag.pr('auto_billing.cmn_state_code' || auto_billing.cmn_state_code);
mmy_edit_passed_flag := 'N';
auto_billing.cmn_error_code := 'EEDIT-7031';
auto_billing.cmn_error_mesg := common_package.get_entity_name('LOCATION', (cmn_location_arr(i).pl_location_code));
auto_billing.ins_edit_log(auto_billing.cmn_error_code, auto_billing.cmn_error_mesg,'abo_edit_check_objects','check_loc_state_pol_state');
auto_billing.cmn_success_failure := '99';
END IF;
END IF;
END LOOP;
diag.pr('END LOOP');

IF mmy_edit_passed_flag = 'Y' THEN
auto_billing.cmn_success_failure := '00';
END IF;
diag.pr('mmy_edit_passed_flag' || mmy_edit_passed_flag);
EXCEPTION
WHEN OTHERS THEN
diag.pr('OTHERS');
auto_billing.print_log('Error in check_loc_state_pol_state due to '||SQLERRM);
auto_billing.cmn_success_failure := '99';
auto_billing.cmn_error_code := 'E-ISS-0003';
auto_billing.cmn_error_mesg := 'check_loc_state_pol_state'||','||SQLERRM;
auto_billing.ins_error_log
(
auto_billing.cmn_error_code,
auto_billing.cmn_error_mesg,
'abo_edit_check_objects',
'check_loc_state_pol_state'
);
END check_loc_state_pol_state;

Need some comments on this error.


Thanks in Advance




Re: ORA-00600: internal error code due to arguments [message #269229 is a reply to message #269227] Fri, 21 September 2007 04:54 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).

ORA-00600 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Previous Topic: How to get Milisecond from systimestamp?
Next Topic: life after COMMIT??
Goto Forum:
  


Current Time: Sat Dec 03 05:41:50 CST 2016

Total time taken to generate the page: 0.23268 seconds