Oracle 10g sort issue

Last year we tried to migrate our LN application to Oracle 10g but had to fail back because 10g presents data in different sort sequence. We had several reports that did not present the data in the same sequence as 9i. This made us leary of sort orders for internal logic in other processing.

We were told by oracle support that we had to add a sort by clause to the query. Since we us LN this is out of our hands.

We want to move our BaanIVc4 environment onto Oracle 10g but given the experience with the LN migration, we are hesitant to attempt it.

Has anyone migrated to oracle 10g from LN or BaanIV?

Find more posts tagged with

Comments

Legacy Contributor

We have not yet migrated to oracle version 10.2 but we are planning to do this in the next couple of months. We currently use Baan IV on oracle 9.2.0.1.

Legacy Contributor

One Oracle 10g R2 bug: (10.2.0.1)

ORA-1445: "ANSI Joins may fail. Can occur for ANSI join queries with
large views/subqueries."
Restriction in Oracle: Max. 6 Joins are allowed
Max. number of fields in the querry (exact value is not known.
LN Script: tsclm100
function: "print.call.document.by.call"
LN System with FP 3

With BaaN IV running on Oracle 10g we had up to now no major issues.

Regards,

Kozure Ohashi

[Updated on 1/20/2009 8:48 AM]

Copyright © 2025 Infor. All rights reserved.