OraFAQ Forum: SQL & PL/SQL » ORA-00600: internal error code

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00600: internal error code (forms 6i and database 10g win xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00600: internal error code [message #648453]

Tue, 23 February 2016 08:53

alshadbik
Messages: 6
Registered: February 2016
Location: yemen

Junior Member

Hi everybody,

I have this code and I receive the above error:

SELECT TO_CHAR(SYSDATE,'YYYY') INTO :GLOBAL.YEAR FROM DUAL ;
DEFAULT_VALUE('***','GLOBAL.USR');
:TOOLBAR.DISPLAY_USERNAME := :GLOBAL.USR;
:TOOLBAR.FORM_NAME := INITCAP(GET_APPLICATION_PROPERTY(CURRENT_FORM_NAME));
:TOOLBAR.FORM_TITLE := LIB_GET_FORM_TITLE_FNC(GET_APPLICATION_PROPERTY(CURRENT_FORM_NAME)) ;
:GLOBAL.DIRECT_OPEN := 'Y' ;
LIB_FORM_TEMPLATE_TRIGGERS_PKG.When_New_Form_Instance ;
--Lib_Set_Privileges_Prc ;

how could I solve this issue...

thanks

Report message to a moderator

Re: ORA-00600: internal error code [message #648454 is a reply to message #648453]

Tue, 23 February 2016 09:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

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

Report message to a moderator

code error [message #648455 is a reply to message #648453]

Tue, 23 February 2016 09:14

alshadbik
Messages: 6
Registered: February 2016
Location: yemen

Junior Member

////////////////////code

SELECT TO_CHAR(SYSDATE,'YYYY') INTO :GLOBAL.YEAR FROM DUAL ;
DEFAULT_VALUE('***','GLOBAL.USR');
:TOOLBAR.DISPLAY_USERNAME := :GLOBAL.USR;
:TOOLBAR.FORM_NAME := INITCAP(GET_APPLICATION_PROPERTY(CURRENT_FORM_NAME));
:TOOLBAR.FORM_TITLE := LIB_GET_FORM_TITLE_FNC(GET_APPLICATION_PROPERTY(CURRENT_FORM_NAME)) ;
:GLOBAL.DIRECT_OPEN := 'Y' ;
LIB_FORM_TEMPLATE_TRIGGERS_PKG.When_New_Form_Instance ;
--Lib_Set_Privileges_Prc ;
////////////////code

Report message to a moderator

Re: code error [message #648461 is a reply to message #648455]

Tue, 23 February 2016 09:55

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals.

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

You posted NOTHING that can help you in any way.

Report message to a moderator

Re: code error [message #648465 is a reply to message #648461]

Tue, 23 February 2016 10:11

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

You really need to debug your form to work out which line is actually throwing the error. It might be in the package for all we know.

Report message to a moderator

Re: code error [message #648481 is a reply to message #648465]

Tue, 23 February 2016 15:20

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here are a few suggestions.

This:

SELECT TO_CHAR(SYSDATE,'YYYY') INTO :GLOBAL.YEAR FROM DUAL ;

could be rewritten as

:global.year := to_char(sysdate, 'yyyy');

Try to recompile ALL the form (Ctrl + Shift + K).

Comment all lines but one; run the form. If it works, uncomment the second line and run the form again. If it works, uncomment the third line and run the form. Etc. until you find the culprit.

Report message to a moderator