| ora-00600 [17069] error problem [message #345368] |
Wed, 03 September 2008 04:26  |
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
|
Junior Member |
|
|
Hello Gurus,
I face following problem in following pl/sql block in form 6i and Database 10g Ver 10.2.0.3.0,
declare
begin
select sysdate into :t1
from dual;
end;
and error is : ORA-00600: internal error code, arguments: [17069],[18798616],[],[],[]
When i use Database 9i, above code work without error.
How to solve this problem, Please help me.
Regards
Brijal
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #345391 is a reply to message #345368] |
Wed, 03 September 2008 06:02  |
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
|
Junior Member |
|
|
Thank LittleFoot for your quick and perfect reply,
It will solve my currenty problem, Now I have same problem in forms and reports. That means I have to change each and every forms and reports for this. It is not possible any solution without chaning code? Can you suggest why this error come?
Regards
Brijal
|
|
|
|
| Re: ora-00600 [17069] error problem [message #345414 is a reply to message #345391] |
Wed, 03 September 2008 08:06 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Sorry, but workaround is the only help I can provide.
| Oracle | ORA-00600: internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition.
Action: Report as a bug - the first argument is the internal error number
|
Therefore, if you'd like to know more about this bug, check Metalink. If you can't find anything helpful, open a TAR (Technical Assistance Request). Hopefully, you'll get the answer.
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #345517 is a reply to message #345368] |
Wed, 03 September 2008 22:50 |
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
|
Junior Member |
|
|
Thanks you for your support,
I every time do Ctrl+Atl+K before Ctrl+T. So David sir it is right or wrong.
And I have in One Report following coding. This is formula column and there is no "Declare" in its coding. As well as i am assigning value to placeholder field so please guide me can we add something before :sal(like block name in Forms).
function DEPTFormula return Number is
begin
....
select sum(:sal) into :CP_net from dual
where :tdept='0061';
...
return 0;
end;
When I remove above line all work fine in DB 10g. but when i add above line it will give me error. I think "Dual" not support in DB 10g. This code work fine in Oracle 9i DB.
Regards
Brijal
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #345536 is a reply to message #345522] |
Thu, 04 September 2008 01:01 |
|
|
| Quote: | I face following problem in following pl/sql block in form 6i and Database 10g Ver 10.2.0.3.0,
|
What version of Forms 6i are you using?
You will not face this problem if you have applied Patchset 18, which i think was the last update for Forms 6i.
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #345568 is a reply to message #345541] |
Thu, 04 September 2008 04:06 |
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
|
Junior Member |
|
|
To LittleFoot sir,
You are right as i check in sqlplusw of DB 10g and dual is work fine there. Then I use plus80w.exe to see dual working or not. And i get positive answer. It work there also.
But problem is in Forms. Same query is giving above error.
To mudabbir sir,
My form version is: Forms [32 Bit] Version 6.0.8.8.0 (Production)
so do i need to download any patch set u suggest? If yes the can u able to give me link so i can download it.
To David sir,
Datatype of t1 is date.
"You need to do the 'sum' from the data table, not 'dual'."
for this i need to recheck all logic of that report as, this report was developed by other person. At that time he use oracle 9i database now I change to new version. So this problem come.
I am confuse.
|
|
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #345834 is a reply to message #345808] |
Fri, 05 September 2008 00:35 |
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
|
Junior Member |
|
|
David sir,
It was previously working on Oracle 9i Database. Now i change database to 10g. Even after change to 10g my old .fmx and .rep file work fine(which was compiled with oracle 9i DB). But now there is change in Report so i open .RDF file and first try to compile without change any code. And this error come.
I do not understand why forms and reports generate this error.
Mudabbir sir,
Thanks for your link. I am right not downloading Oracle_Forms_6i_Patch_18.exe. ok? And if this work successfully, do i have to download any thing extra for Report 6i? Or this update will work for Report also.
Regards
Brijal
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #346277 is a reply to message #346229] |
Mon, 08 September 2008 01:09 |
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
|
Junior Member |
|
|
David sir,
you are right, This was in Form 6i code. But the person who working previously in this form has use dual table many places, so I told i have this code in Report also.
Thanks you all again. This debate help me lot.
Regards
Brijal
|
|
|
|
| Re: ora-00600 [17069] error problem [message #439455 is a reply to message #345368] |
Sun, 17 January 2010 01:36 |
FaridGhori
Messages: 2
Registered: January 2010
Location: Pakistan
|
Junior Member |
|
|
Connect with Application User through SQL Developer/ Plus/ Cmd:
SQL> create table dual as select * from dual;
No need to RE-compile any of the Oracle developer file!
Thanks,
Farid Ghori
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #439549 is a reply to message #345368] |
Mon, 18 January 2010 04:26 |
FaridGhori
Messages: 2
Registered: January 2010
Location: Pakistan
|
Junior Member |
|
|
Dear Michel,
I can understand the optimization issue while using dual table instead of public synonym, BUT how can we get database server date&time in developer6i with Oracle 10g XE?
Example:
declare
begin
select sysdate into :t1
from dual;
end;
ERROR:
ORA-00600: internal error code, arguments: [17069],[18798616],[],[],[]
Alternate Posted Solution by Littlefoot:
currentDate := sysdate;
--1. Non database server date time.
--2. We will have to change to code in each form & report to use current date & time.
Please post any other best solution for the same.
Thanks & Regards,
Farid.
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #439551 is a reply to message #439549] |
Mon, 18 January 2010 04:35 |
cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
FaridGhori wrote on Mon, 18 January 2010 10:26Alternate Posted Solution by Littlefoot:
currentDate := sysdate;
--1. Non database server date time.
Where did you get that idea? Sysdate is sysdate is sysdate. Just because you're not selecting it from dual doesn't change the answer. It's not a column of dual it's a function.
|
|
|
|
|
|
|
|
|
|
| Re: ora-00600 [17069] error problem [message #448288 is a reply to message #345368] |
Mon, 22 March 2010 09:16 |
gregor
Messages: 86
Registered: March 2010
Location: Germany
|
Member |
|
|
hi ,
1.) The Table "SYS.DUAL" exists in ORACLE DB 10g.
-> "Select 'whatever' from dual" works in Oracle-10g.
2.) Check your user has "SELECT-Privileges" on SYS.DUAL,
normaly exits the Privilege (" GRANT SELECT ON SYS.DUAL TO PUBLIC WITH GRANT OPTION") on this table.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
