Home » Developer & Programmer » Reports & Discoverer » ORA-00600 internal arguments (report 6i)
ORA-00600 internal arguments [message #667967] Mon, 29 January 2018 00:56 Go to next message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
function WWFormula return Number is
A NUMBER;
begin
 select trunc((last_day(dt) - trunc(dt,'iw') + 1) / 7) * 6 +
          least(mod(last_day(dt) - trunc(dt,'iw') + 1,7),6) -
least(dt - trunc(dt,'iw'),6) 
   INTO A from  (
           select  add_months(to_date('01-MAR-2017','DD/MM/YYYY'),level - 1) dt
             from  dual
             connect by level <= 12);
         return(a);
end;
The above query is works fine in xp, oracle 9i and reports 6i. but we have upgrade to win 7 32bit, oracle 10g, report 6i. this function return error.
Ora-00600 internal error , arguments [17069',[25091004],[],[],[]
please advised.
Re: ORA-00600 internal arguments [message #667970 is a reply to message #667967] Mon, 29 January 2018 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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.
And MOS notes:
ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)
Master Note for Diagnosing ORA-600 (Doc ID 1092832.1)

Re: ORA-00600 internal arguments [message #667973 is a reply to message #667970] Mon, 29 January 2018 08:50 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Surely that function should throw too_many_rows every time you run it. Since that query returns 12 rows by design.
Re: ORA-00600 internal arguments [message #667983 is a reply to message #667973] Mon, 29 January 2018 13:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Additionally, I'd match date format & its mask.

no : to_date('01-MAR-2017', 'DD/MM/YYYY')
yes: to_date('01-mar-2017', 'dd-mon-yyyy')

Although, I prefer non-language dependent dates, i.e.
no : to_date('01-mar-2017', 'dd-mon-yyyy')
yes: to_date('01.03.2017', 'dd.mm.yyyy')
because - as soon as NLS_DATE_LANGUAGE changes, the above might not work any more.

That probably won't fix ORA-00600, but nonetheless ...
Re: ORA-00600 internal arguments [message #667993 is a reply to message #667983] Tue, 30 January 2018 03:04 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well either that's not the real code or the only reason it ever worked is due to a bug which is fixed in the higher version.
If it's the later then the ORA-600 isn't worth worrying about, OP should first come up with a function that won't throw too_many_rows and then see what happens.
Previous Topic: adding sysdate while generate pdf file.
Next Topic: water mark
Goto Forum:
  


Current Time: Thu Mar 28 16:47:29 CDT 2024