Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> select count(distinct col) with nulls, how to supress the warning messages
mjschwenger
post Feb 1 2007, 03:01 PM
Post #1


Advanced Member
***

Group: Members
Posts: 206
Joined: 22-June 05
Member No.: 2,347



I have a problem with the application that issues a select distinct count of a column that has NULLS value on Oracle 10.1.0.4. The application doesn't handle the warning message returned and shuts down. I cannot change the application code… neither to recompile. Is there a way to suppress the warning messages so the application will not stop?
Below is the exact statement that causes the problem, but I cannot reproduce it in QA. I guess it does handle the nulls for me.

create table testing_bug (id number, col1 varchar2(50))

insert into testing_bug values(1, 'ttt');

insert into testing_bug values(19, null);

insert into testing_bug values(12, 'nnn');

insert into testing_bug values(15, 'mmm');

insert into testing_bug values(14, 'yyy');


select count(distinct col1) from testing_bug


Of course, I looked at Metalink and all the articles there for fixing on the OCI calls and recompiling the application, but I cannot do that at the moment - has to keep the application the way it is?
Any other idea for work around in the time while I could obtain a new application copy?

Thanks a lot, mj
Go to the top of the page
 
+Quote Post
mjschwenger
post Feb 2 2007, 10:56 AM
Post #2


Advanced Member
***

Group: Members
Posts: 206
Joined: 22-June 05
Member No.: 2,347



The return code is ORA-24347: Warning of a NULL column in an aggregate function.
I researched more on Metalink and found 2 posts where this error is dependant on the client version - people saying that the same select with standard Client 9.0.2.0 (OCI driver) is OK - did not try it yet...
I just needs a work aroung till I get a new application copy - but it could take a while...

Thanks a lot , mj
Go to the top of the page
 
+Quote Post
mjschwenger
post Feb 2 2007, 01:08 PM
Post #3


Advanced Member
***

Group: Members
Posts: 206
Joined: 22-June 05
Member No.: 2,347



Not really - All I found was fixed in 8.1.7 top.
But there's a post that show this problem on 10.1.0.2 and the same person claims that this issue doesn't exist on 9.2.0.2. Unfortunately, there's no resolution to the bug posted...
here is the link:
https://metalink.oracle.com/metalink/plsql/...:636454.995,1,1

Thanks, mj
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 21st October 2014 - 05:17 AM