No question at this time
DBA Top 10
1 M. Cadot 16900
2 A. Kavsek 15000
3 B. Vroman 10300
4 M. Hidayathullah ... 8400
5 T. Boles 4700
6 P. Wisse 4400
7 J. Schnackenberg 3500
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 800
9 T. P 800
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48095
Total active users1706
Act. users last 24h8
Act. users last hour0
Registered user hits last week389
Registered user hits last month1490
Go up

Oracle 12c ORDER BY
Next thread: Hierarchy Query, Same level and sublevel with sum., count
Prev thread: When trying to connect to database using sqlplus it hangs

Message Score Author Date
Hello, We have an application written in Delphi...... Peter Smeets Dec 01, 2017, 13:46
Hi, > What could be the cause? Bug. Open SR...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Ales Kavsek Dec 01, 2017, 14:23

Follow up by mail Click here


Subject: Oracle 12c ORDER BY
Author: Peter Smeets, Belgium
Date: Dec 01, 2017, 13:46, 13 days ago
Os info: Microsoft Windows 64bit
Oracle info: 12.1.0.2.0 64bit
Error info: ora-03113 end-of-file on communication channel
Message: Hello,

We have an application written in Delphi10 using ODAC to connect to the Oracle database.

The following query works fine in Oracle 11g:

SELECT a.*, :language as language
FROM mttrnosh a
WHERE a.company = :company
AND a.codelocation = :codelocation
AND a.location = :location
AND a.month = :month
ORDER BY a.sellingdate

In 12c this raises an ora-03113 the 4th time that the query is executed. The first 3 times the result is ok and no error is raised?!

The solution is to change the order by into:
ORDER BY To_Char(A.sellingdate, 'YYYYMMDD')

What could be the cause?


Thank you for your attention.

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Oracle 12c ORDER BY
Author: Ales Kavsek, Slovenia
Date: Dec 01, 2017, 14:23, 13 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hi,

> What could be the cause?

Bug. Open SR on MOS.

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here