Home » Developer & Programmer » Forms » ora-00600 [17069] error problem (Form 6i, Database 10g)
ora-00600 [17069] error problem [message #345368] Wed, 03 September 2008 04:26 Go to next message
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 #345374 is a reply to message #345368] Wed, 03 September 2008 04:53 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try with
:t1 := sysdate;
or, if possible, modify t1's "Initial value" property to $$date$$ (or $$datetime$$ if you need date + time).
Re: ora-00600 [17069] error problem [message #345391 is a reply to message #345368] Wed, 03 September 2008 06:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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 #345498 is a reply to message #345368] Wed, 03 September 2008 20:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did you do a Ctrl-Shft-k before doing the Ctrl-t?

If the same code exists in many forms then I expect that it should be a referenced object. Take this opportunity to make it so.

Try removing the 'declare' and also prefix the use of the item (t1) with its 'block' name.

David
Re: ora-00600 [17069] error problem [message #345517 is a reply to message #345368] Wed, 03 September 2008 22:50 Go to previous messageGo to next message
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 #345522 is a reply to message #345517] Wed, 03 September 2008 23:34 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I should also have asked what is the datatype of the item 't1'.

You need to do the 'sum' from the data table, not 'dual'.

David
Re: ora-00600 [17069] error problem [message #345536 is a reply to message #345522] Thu, 04 September 2008 01:01 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

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 #345541 is a reply to message #345517] Thu, 04 September 2008 01:45 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
brijal_j_patel
I think "Dual" not support in DB 10g.
And I think that you are very wrong about it.
Re: ora-00600 [17069] error problem [message #345568 is a reply to message #345541] Thu, 04 September 2008 04:06 Go to previous messageGo to next message
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 #345571 is a reply to message #345568] Thu, 04 September 2008 04:13 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

http://www.epa.gov/storet/updates.html
Re: ora-00600 [17069] error problem [message #345808 is a reply to message #345568] Thu, 04 September 2008 21:26 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please confirm that the code: "select sum(:sal) into :CP_net from dual where :tdept='0061';" is existing code and that it has been working successfully.

David
Re: ora-00600 [17069] error problem [message #345834 is a reply to message #345808] Fri, 05 September 2008 00:35 Go to previous messageGo to next message
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 #345845 is a reply to message #345834] Fri, 05 September 2008 01:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please confirm whether this code "select sum(:sal) into :CP_net from dual where :tdept='0061';" is in a Form or a Report?

David
Re: ora-00600 [17069] error problem [message #345884 is a reply to message #345368] Fri, 05 September 2008 03:42 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
David sir,
This code is in Report 6i. I all ready give details about this query before.
Regards
Brijal
Re: ora-00600 [17069] error problem [message #345977 is a reply to message #345368] Fri, 05 September 2008 07:54 Go to previous messageGo to next message
kamu
Messages: 5
Registered: September 2008
Junior Member
brijal_j_patel wrote on Wed, 03 September 2008 04:26

declare
begin
select sysdate into :t1
from dual;
end;




can you try this code my friends..

select sysdate into :t1
from sys.dual;



regards...
Musti

[Updated on: Fri, 05 September 2008 07:54]

Report message to a moderator

Re: ora-00600 [17069] error problem [message #346095 is a reply to message #345977] Fri, 05 September 2008 23:10 Go to previous messageGo to next message
brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India
Junior Member
Musti sir,
Thanks for your valuable help. This solve my problem.
Thank to all and also this on-line site hosting form.
Regards
Brijal
Re: ora-00600 [17069] error problem [message #346229 is a reply to message #345884] Sun, 07 September 2008 19:23 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I'm glad you solved your problem, but your initial post says "I face following problem in following pl/sql block in form 6i and Database 10g Ver 10.2.0.3.0" then later you mentioned reports, that's why I had to ask.

David
Re: ora-00600 [17069] error problem [message #346277 is a reply to message #346229] Mon, 08 September 2008 01:09 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #439456 is a reply to message #439455] Sun, 17 January 2010 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Very bad idea.
Accessing original dual table is something known from the optimizer which actually does NOT access any table.
If you use your table instead then you have to access the table each time, now count the number of "from dual" you have in your code and the number of times these part of code are accessed without speaking of contention in accessing the table block in the buffer cache: only one can read it at each time.

Regards
Michel
Re: ora-00600 [17069] error problem [message #439549 is a reply to message #345368] Mon, 18 January 2010 04:26 Go to previous messageGo to next message
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 #439550 is a reply to message #439549] Mon, 18 January 2010 04:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you fall into a bug using dual you cannot workaround it just by creating your own.
The whole Oracle program relies on DUAL.
So you must find the root of this error.

Regards
Michel
Re: ora-00600 [17069] error problem [message #439551 is a reply to message #439549] Mon, 18 January 2010 04:35 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
FaridGhori wrote on Mon, 18 January 2010 10:26
Alternate 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 #447635 is a reply to message #345368] Wed, 17 March 2010 00:11 Go to previous messageGo to next message
sumon_ora
Messages: 1
Registered: March 2010
Location: dhaka
Junior Member
Dear brijal_j_patel,
Please send me an active link for downloading patchset 18 or send me to sumonarifur@yahoo.com.

Thanks
Sumon
Re: ora-00600 [17069] error problem [message #447750 is a reply to message #439551] Wed, 17 March 2010 13:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@FaridGhori:

Huh, creating your own DUAL table looks like a really bad idea.

As previously said, SYSDATE is a function; you don't need the DUAL table to get its result. For example:
SQL> select sysdate from dept;

SYSDATE
----------
17.03.2010
17.03.2010
17.03.2010
17.03.2010

SQL>
But, as DUAL contains a single record, it will return a single value. I can do that too with the DEPT table, but - why would I want to do that when DUAL is alive and kicking?
SQL> select sysdate from dept where rownum = 1;

SYSDATE
----------
17.03.2010

SQL>


@sumon_ora:

Patches are available at My Oracle Support, if you are allowed to get them. I don't think that mailing them over to you is a legal action.
Re: ora-00600 [17069] error problem [message #448006 is a reply to message #447635] Fri, 19 March 2010 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@sumon_ora

Do not report a message just to get an answer above all when what you ask is in the answer you already got.

Regards
Michel
Re: ora-00600 [17069] error problem [message #448288 is a reply to message #345368] Mon, 22 March 2010 09:16 Go to previous messageGo to next message
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.
icon14.gif  Re: ora-00600 [17069] error problem [message #451550 is a reply to message #345568] Thu, 15 April 2010 06:35 Go to previous message
alithegr8@gmail.com
Messages: 5
Registered: February 2009
Location: Saudi Arabia
Junior Member
Dear,

Thanks a lot for sharing the information. I faced the same issue and I was able to fix it by installing the recommended pathset_18.

Thanks a lot.
Previous Topic: Changing the Visiual attributte of Textfield On mouse over in oracle forms 9i
Next Topic: Run oracle forms on client machine
Goto Forum:
  


Current Time: Fri Dec 09 08:10:34 CST 2016

Total time taken to generate the page: 0.15062 seconds