ORA-00600 internal arguments [message #667967] |
Mon, 29 January 2018 00:56 |
shahzad-ul-hasan
Messages: 643 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 #667983 is a reply to message #667973] |
Mon, 29 January 2018 13:43 |
|
Littlefoot
Messages: 21823 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 |
cookiemonster
Messages: 13963 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.
|
|
|