OraFAQ Forum: Forms » Migrating from oracle 8i to oracle 10g

Home » Developer & Programmer » Forms » Migrating from oracle 8i to oracle 10g

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

Migrating from oracle 8i to oracle 10g [message #473682]

Tue, 31 August 2010 02:54

alister
Messages: 101
Registered: August 2007
Location: India

Senior Member

Hi to everyone

I have migrated from Oracle 8i (8.1.7) to Oracle 10g, but when I execute a query in 8i without any order by clause, I get a result in ascending order. The same query when executed in 10g gives a result which is not ordered. Can anyone advise me as to how to get an order result in 10g. There are many forms and reports which use lov which are not ordered. Can I set the ordering at the database, so that I do not have to alter all the forms and reports.

I have also migrated my forms from 5 to 6, but the combo box in some forms in 6i do not appear at run time. Please show me how I can solve this problem. I have attached an forms5 .fmb file/

Regards

Alister

Attachment: AFBKR50.fmb
(Size: 56.00KB, Downloaded 1097 times)

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #473683 is a reply to message #473682]

Tue, 31 August 2010 03:06

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

Senior Member
Account Moderator

There is only ONE way to get an order: use and ORDER BY clause.

Regards
Michel

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #473996 is a reply to message #473683]

Wed, 01 September 2010 22:12

alister
Messages: 101
Registered: August 2007
Location: India

Senior Member

But why does the same query give me the result in one order in 8i and another order in 10g. Is there any internal ordering ie the way data is stored in the different databases.

Regards.

Alister

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #474021 is a reply to message #473996]

Thu, 02 September 2010 01:57

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

Senior Member

You got lucky.
Most likely due to the 8i using the RBO which decided to retrieve the data for that query via an index so got it in the order of that index.
In 10g the CBO decided to get the data a different way.

Bear in mind that even in 8i there are things that could have changed that would have stopped that query returning data in that order. Hence - you got lucky. It's nothing to do with how it's stored.

You need to add order bys.

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #474118 is a reply to message #474021]

Thu, 02 September 2010 22:11

alister
Messages: 101
Registered: August 2007
Location: India

Senior Member

Thank you, I guess I really got lucky. Can someone please tell me why to combo box does not appear at run time in forms 6i. The same was working fine in forms 5.

Regards

Alister

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #474146 is a reply to message #474118]

Fri, 03 September 2010 03:43

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

Senior Member

Best guess for the combo boxs is there is a problem with the sub-class. Try removing it and see if they appear

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #474533 is a reply to message #474146]

Mon, 06 September 2010 22:11

alister
Messages: 101
Registered: August 2007
Location: India

Senior Member

I found the maximum length of the data was 1 char, so I increased it to 9 and the combo box appeared at run time and worked fine. My question is why is the combo box working with a char length of 1 in forms 5 and not so in an higher version ie forms6 for the same data.

Alister

Report message to a moderator

Re: Migrating from oracle 8i to oracle 10g [message #474536 is a reply to message #474533]

Tue, 07 September 2010 00:08

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

Senior Member
Account Moderator

Perhaps because something changed between those two versions. What it was, probably can be found in New features guide.

Report message to a moderator

Previous Topic:	Re Modify run report
Next Topic:	Fetching Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 12:54:55 CDT 2024